How do I get the percent showing in the pivot table to show the percentage of a1/b1 =c1 as percent... (ie) as in row ... 66/718 = 9.2% . I see "show percent as ... (row total, column total etc.) but each goes to the "Total" figure. I need a simple line (row) comparing side by side numbers calculating percents.
As below.
1 736 134 18.2%
2 718 66 9.2%
3 627 94 15.0%
4 1225 187 15.3%
5 916 136 14.8%
New to this process ... am i missing such a simple process in this excellent tool??
Tia
Bookmarks