C
ColG
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.
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.