Not and keep it a pivottable.
I copy the pivottable to a new worksheet and paste|special values. That copy is
no longer a pivottable, but I can do anything I want to the data.
Including following these techniques from Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html
" wrote:
On Apr 25, 10:16 am, "
wrote:
I'm not sure how to ask this, but here goes. A pivot table show only
that data at each break in the sort. For example if I had a car
database with manufacturer, model, and count, the pivot table might
show this
Chevy Malibu 10
Corvette 20
Ford F150 5
Tempo 15
Dodge charger 3
Sorry I pulled the trigger too quickly. Anyway, is there a way to
show Chevy for each row that applies to Chevy, Ford for each for row
that applies to Ford etc etc. I have a formula that I can do this
outside of the pivot table but would like this within the pivot
table. Thanks
--
Dave Peterson