Filter pivot table zero values

R

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!
 
D

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!
Click to expand...

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter list not correctly refreshed 3
pivot table rolling 12 month filter? 1
OLAP Pivot Table Calculations 4
Hide zero values in a pivot table 3
pivot table value filter 1
Pivot table layout that popluates the row label in each row? 3
Single Filter to change all Pivot Tables in a Workbook 8
Pivot Table - Hiding Zero Values 2

Top