Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
Office 2003 pivot table filter data values | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Pivot table: filter values great then, lower then... | Excel Discussion (Misc queries) | |||
Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions |