I'm working with a Pivot Table on Excel for Mac 2011.
I can't seem to find an option to show items with no data.
I recall on a Windows computer, there is simply a check box, but I can't seem to find it on Mac.
Eg. I'm doing a sales report and want to compare the quarters of the previous two years. There are some instances where there have been no sales in a year. I would prefer the line for the year to be there, but with blank or zero values (rather than the line not being there at all).
Do you know how to do this?
I can't seem to find an option to show items with no data.
I recall on a Windows computer, there is simply a check box, but I can't seem to find it on Mac.
Eg. I'm doing a sales report and want to compare the quarters of the previous two years. There are some instances where there have been no sales in a year. I would prefer the line for the year to be there, but with blank or zero values (rather than the line not being there at all).
Do you know how to do this?