I have this table:
So on the far right column, I'm trying to get the average deal size based on the sum column. By default, PBI is taking $312,994.57 and dividing it by 423 (the number of times a person is in the table) which comes out to $739.94.
However, if I export this to an excel file and highlight the far right column from top to bottom, I get $1,158.40 as the average which would be the correct average. How can I get PBI to calculate it that way rather than just doing $312,994.57/423?
Solved! Go to Solution.