show pages on a pivot in 2007
 

How do I do a "show pages" on a pivot table in Excel 2007??? I did it in
2003, but can't figure out how to do it in 2007.

Thanks!

show pages on a pivot in 2007
 

Hi,

Click on the report filter cell of the pivot and then go to Pivot Table
Tools Options Pivot Table Options Show Report Filter Pages

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"terri" wrote in message
...
How do I do a "show pages" on a pivot table in Excel 2007??? I did it in
2003, but can't figure out how to do it in 2007.

Thanks!