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.
 
Have you tried dropping the field you want on the "row" section of the pivot
table?
 
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.
 
You must log in or register to reply here.

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 counting values 1
Pivot Table 1
Pivot Table 2
Pivot table wizards 2
Pivot tables - counting unique numbers 2
Pivot Tables 1

Back
Top