hi
How to efficiently solve this problem?
Data:
Name US Europe
A 3 6
B 2 4
C 8 9
PivotTable:
Row Lables = Name
Values = Sum of US1, and Sum of Europe
This gives a summary of absolute values.
Now - I want to see the data as % - ie A should have 33% in US, and 67%...