How to list items instead of counting them with Pivot Table


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.
 
Ad

Advertisements

A

A_Sneller

Have you tried dropping the field you want on the "row" section of the pivot
table?
 
Ad

Advertisements

C

coolthinking

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

Top