View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
coolthinking coolthinking is offline
external usenet poster
 
Posts: 5
Default How to list items instead of counting them with Pivot Table

Hello,
Under Excel 2003, I have a worksheet with several columns. When using the
Pivot Table I am able to select count, sum... possibility for the data part
of the Pivot Table Layout Wizard. It works great and I am happy.
However, I would like now to list the items instead. How can I do it?
I use around 20 differents PivotTable on my Excel document, so Advanced
Filtering is not the solution for this case.
Best regards.