How do I display Values in pivot table?

[Tim-1000A]

When I create a pivot table (Excel 97) rather then count, sum, etc the
values, I simply want to display the values. Not just the min, max etc. I
want to display them all. They can be in one cell or many. Any suggestions?
Thanks - Tim

 

[JulieD]

Hi Tim

the purpose of pivot tables is to summarise data ... and i can envisage how
you could practically display the answers like you want anyway, e.g. if you
have 7 sales records for shoes in january a "normal" pivot table would show
Jan
Shoes 3

but what you're asking for (if i'm understanding correctly) is

Jan
Shoes 1
Shoes 1
Shoes 1

- which is basically like the underlying data ...
does Data / Filter / AutoFilter
or Advanced Filter
give you what you want.

Cheers
JulieD