How to list items instead of counting them with Pivot Table

  • Thread starter Thread starter coolthinking
  • Start date Start date
C

coolthinking

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.
 
Hello, yes I tried without success as when moving to the row, the data part
remains empty and it is not accepted by the PivotTable Layout wizard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot (Data Items "Count" vs "Sum") 2
Counting number of items excluding duplicates. 1
Pivot Table 2
Pivot Table counting values 1
Pivot Table 1
Pivot table wizards 2
Pivot tables - counting unique numbers 2
Pivot Table Data Column Sort Excel 2007 1

Back
Top