How do I display Values in pivot table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim-1000A - 30 Sep 2004 13:51 GMT

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

Reply to this Message

JulieD - 30 Sep 2004 14:34 GMT

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

> 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

Reply to this Message