If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter pivot table zero values
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! |
#2
|
|||
|
|||
Filter pivot table zero values
On Sep 17, 1:12*pm, rebecca wrote:
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). |
Thread Tools | |
Display Modes | |
|
|