Calculate % in pivot table

[Alpha1980]

I have a pivot table with the following headers:

Customer | Count of Patients | Sum due service
Healthcare Area 1 | 100 | 10

How do I add another column that will calculate compliance %? e.g. 90%

Thanks in advance.

 

[DRANDON]

Greetings. Click anywhere on Pivot Table. On Pivot Table toolbar find "Pivottable" (with a tiny arrow pointing down next to it) - choose "Formulas" - choose "Calculated Field.."

Where it says "Add" type in a header name of your choice. Using the fields available insert
"Sum Due Service" / "Count of Patients" then click the button "Add"

Ok your way out.. (you may have to format the cells to percentage)

Hope this helps.

 

[Alpha1980]

Thanks Drandon.

For some reason, I'm not getting the expected result.

I'd like to attach an attachment but I don't have permission.

 

[DRANDON]

Alpha1980,

send to drandon.campbell@gmail.com