I have data in a pivot table that changes when I change the report filter. The format that I want to preserve is this:
(All)
QUOTES QUOTES ORDERS ORDERS
2011 2012 Grand Total
2011 2012
23 0 8 0 31
6 0 20 2 28
The four columns I want to always be there, even if there is no data in those columns. How do I make sure the pivot table preserve's these columns so when I change the report filter it doesn't look like this:
QUOTES ORDERS
2011 Grand Total
2011
1 1 2
1 1 2
Thanks,
J
Bookmarks