I have the following data:
Region - Revenue
South - 1
North - (Blank)
West - 3
When I constructed a pivot it looks like this:
I have already made sure that the check box "Show items with no data" is unchecked for the Region field.
So why is pivot still showing items with no data? How do I make it hide items with no data?
Thanks
Region - Revenue
South - 1
North - (Blank)
West - 3
When I constructed a pivot it looks like this:
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
3 | SumofRevenue | |||||
4 | Region | Total | ||||
5 | North | |||||
6 | South | 1 | ||||
7 | West | 3 | ||||
8 | GrandTotal | 4 | ||||
Sheet1 |
I have already made sure that the check box "Show items with no data" is unchecked for the Region field.
So why is pivot still showing items with no data? How do I make it hide items with no data?
Thanks