Help with pivot table field, show data as

Copper Contributor

Hello, thanks ahead of time for your help. I am trying to show the values in two columns of a pivot table as percentages of a total. I would like the values in column E to be percentages of the total in column C (i.e. E2/C4 and E3/C4). I would also like F to be a percentage of C but of the row total not state total (i.e. F2/C2 and F3/C3). In the image below columns G, H, and I are all hard coded by me to show the values I'm looking for. I believe I have tried all the arrangements under "Show data as" in pivot table options.

 

Screenshot 2023-03-14 at 11.20.53 AM.png

 

 

 

 

 

Screenshot 2023-03-14 at 11.49.15 AM.png

0 Replies