Forum Discussion
Calculated Field for Pivot Table - Unable to Calculate
I have two values shown in my pivot table per department, Count of People and Sum of People Using Widgets. I want to divide the Sum of People Using Widgets by the Count of People to get a percentage ...
Hello CarlW ,
how do you create the calculated field? In this screenshot, I divide the columns by one another. The #Div/0 error only shows if the people column is zero.
Thanks for the quick response IngeborgHawighorst
I created the formula in the same way. Because the People field is a count of how many people there are, I am wondering if it can't calculate this because the basis for the counts is people's names. It can't do calculations based on the source data.
CarlW can you post a small data sample? You can attach a workbook. Just make sure to replace confidential data with fake data.
