Showing all rows in a pivot table
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 |
Showing all rows in a pivot table
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 |
Showing all rows in a pivot table
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 |
All times are GMT +1. The time now is 12:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com