Filter pivot table zero values

[rebecca]

We have an Excel data services report pulling pivot charts from an
OLAP cube.

Is there a way to filter the zero values so those lines don't show?
These values are showing up in the Data section.

Thank you!

 

[David Weston]

We have an Excel data services report pulling pivot charts from an
OLAP cube.

Is there a way to filter the zero values so those lines don't show?
These values are showing up in the Data section.

Thank you!

Add filters to the data section headings and then use the Grand Total
filter to only show those values not equal to zero.

To add filters to the headings, start your cursor one cell to the
right of the Grand Total heading and highlight across. Then choose
AutoFilter (Data > Filter > AutoFilter).