Pivot Table Display

  • Thread starter Thread starter td
  • Start date Start date
T

td

I have created a pivot table with the following
parameters:

Page Area = Customers
Row Area = Product
Column Area = Month
Data Area = Sales $

When I select a specific customer, it displays only those
months that have sales. I would like it to display all
months as that I can use the GETPIVOTDATA function.

Any suggestions?

Thanks
 
In the PivotTable, double-click the Month button.
Add a check mark to 'Show items with no data', and click OK
 
Back
Top