Pivot Table Display

[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

 

[Debra Dalgleish]

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