Pivot Table Question

[Guest]

I'm trying to find out if there is way to tell Excel when doing a Pivot Table
NOT TO SUPPRESS VALUES when they are repeated (i.e. if a column is a listing
of names and the data is sorted by name, the pivot will only show you the
first occurrence of the name until it gets to the next one, then it will show
you that name). I'm trying to find a way for it to always show me the name.

I use Excel 2003, by the way.

Thanks.

 

[Dave Peterson]

I don't think so.

I usually copy and paste special|values--either over the pivottable or on a new
sheet.

Then I fill in that to make it look like I want.
http://contextures.com/xlDataEntry02.html
(From Debra Dalgleish's site)

 

[Guest]

Thank you!

I don't think so.

I usually copy and paste special|values--either over the pivottable or on a new
sheet.

Then I fill in that to make it look like I want.
http://contextures.com/xlDataEntry02.html
(From Debra Dalgleish's site)