I want to add a calculation to a pivot table taking one count value (sum of total entries not the sum of the data values) and divide it by another count value that results in a %. I have tried multiple formulas, and nothing seems to work so I have made the calculations outside of the pivot table which means that any change to the pivot table requires me to manually update the calculated fields that are outside of the pivot table.
Any assistance is greatly appreciated!
Hi Dan,
Hard to say without the context of the file, but please see this tutorial on calculated fields: https://www.myonlinetraininghub.com/excel-pivottable-calculated-fields
If that doesn't work, then it will require loading your data to the Power Pivot data model and using DAX measures for the calculation. DAX measures allow more complex formulas than we can create with calculated fields and items in regular PivotTables.
Mynda
