Pivot Table Display

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

td wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html