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

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

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