I am attempting to get the same percentage result as if I created a calculated field in a pivot table of numerator/denominator. However, I am trying to achieve this with PowerPivot as the source for the pivot table. I created new column 'Percent = [num]/[denom] (among other variations) but it does not calculate based on the summing of Num and Denom in the pivot table. Below "PERCENT" is what I am trying to get to. As mentioned, I could do this with the calculated field option in "Fields, items & sets" but that option is greyed out when connected to powerquery. Thanks for any help it is appreciated!!
Name Num Denom PERCENT The calc
Jill 13658 25603 53% 13658/25603 = 53%
John 2311 10285 22% 2311/10285 = 22%
Bob 356 2469 14% 356/2469 = 14%
Name Num Denom PERCENT The calc
Jill 13658 25603 53% 13658/25603 = 53%
John 2311 10285 22% 2311/10285 = 22%
Bob 356 2469 14% 356/2469 = 14%