Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
I have a simple pivot table with classes and number of people who attend each class (as below). What I would like is for where there is no corrsponding figure for a class, I don't want to see it on the pivot table. My Pivot Table Excel 100 Word 150 Outlook Access 80 What I would like to see is only those rows with figures Excel 100 Word 150 Access 80 I know that I could filter in the pivot table and manually choose the classes above. However, is there any setting or any way that this can be automated? Many thanks for any help on this matter. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot table (blank) | Excel Discussion (Misc queries) | |||
pivot table (blank) vs. __ | Excel Discussion (Misc queries) | |||
Pivot table creates blank table | Charts and Charting in Excel | |||
Pivot Table with Blank Rows - HELP | Excel Discussion (Misc queries) | |||
Pivot Table Row Cell (Blank) | Excel Worksheet Functions |