% of 2 cells in a pivot table

[SandsB]

I'm doing a pivot table. There are rows for each person on my team. Column B is "Total Tickets", Column C is number of those tickets per person that are closed - field name is "Status". I need column D to show each person's % of closed tickets. I can manually enter =C10/B10, etc but I want to learn how to do this as part of the pivot table so I can sort the results and do the same thing in other pivot tables. Is it possible?

 

[HolyExcel]

when you are in the pivot table with the cursor there is the analysis menu at the top. there you can add calculated items.

 

[SandsB]

I forgot to mention I'm not good at figuring things out for myself.

https://youtu.be/tNfGyIW7aHM

 

[HolyExcel]

well then: https://youtu.be/9imJEO2IT-8

 

[SandsB]

I'd found a video nearly identical to that one and entered this for my formula: ='Status' / 'Total Tickets' and the results come back as #DIV/0! in every row.

 

[HolyExcel]

which would mean that your total tickets numbers are 0?

 

[SandsB]

None are 0

 

[HolyExcel]

check your inbox pls

 

[SandsB]

I don't see anything