Hi, I'd like to display two data points in a single pivot table - the count of the base data, as well as the percentage of the row. I know how to do one or the other, but is it possible to build a table which displays both next to one another?
I have a list of account groupings as row fields. The column field has several account types. The data field is a count of the number of accounts within a group that falls into each type. I'd like to display not only the count (the actual number of accounts within a group in each type), but the percentage that count represents of the total within that row. Something like this:
Count Type 1 Type 2 Type 3 Total
Group 1 10 20% 15 30% 25 50% 50 100%
Group 2 33 23% 21 15% 88 62% 142 100%