Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove items with no data from pivot
I have some pivots that are used in several different
sheets exactly with the same format and base external tables, where i just chenge the criteria through Microsoft Query. The problem is that the original data from the first pivot i used as a model, remains in the pivot all the time. You check this because if you choose the options "Show items with no data", all the items from my first table model will show, even if they no longer are part of the new criteria. Summarizing: is there a way to remove items with no data from a pivot field? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - show items with no data | Excel Discussion (Misc queries) | |||
Remove grouped items and fields from pivot table | Excel Discussion (Misc queries) | |||
How can I remove old items in a drilldown box in a pivot table? | Excel Discussion (Misc queries) | |||
How do I combine four data items into one in a Pivot Table? | Excel Discussion (Misc queries) | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) |