Basically, what I'm trying to do is to present data in a pivot table, but include summary results of a different group. See attachment for full example.
I'd like to have the results that are in parenthesis in the example below as the summary of the pivot (% of Old Class in New Class).
Detail of Data:
Inv ID Description Old Class New Class Total New Class Sum
1 Dodge Car 4-Wheeler $5,000 5000
2 Mongoose Bike 2-Wheeler $200 1000
3 Yamaha Motorcycle 2-Wheeler $700 1000
6 Vespa Scooter 2-Wheeler $50 1000
4 Vespa Scooter 2-Wheeler $50 1000
5 Can Am Motorcycle 3-Wheeler $80 80
What I'd like to see in a pivot table:
Old Class / New Class (% of Old Class in New Class)
2-Wheeler 200 / 1000
I'm able to put the numerator and the denominator as different summary values in the pivot. What I'm not able to do is to divide the two.
I've also tried to add a calculated field and noticed that when I count a calculated field, I get a different result from using the summary type of count in the pivot, but the sum of a calculated field gives the same result as the sum of the pivot summary type. (see attachment for better explanation).