Column Calculations

[ACraig08]

Hello, I have a field "% of Cost" that is a calculated column dividing the Total Cost by the Cost. It is added to a table like this...

I am trying to figure out how instead of the total at the top summing the percentages it could show the percentage of the Total Cost/Cost totals. So I wrote in red what I would like it to show (980,857/9,079,297).

I hope that made sense!

Thank you!

[SundarRaj]

Hi @ACraig08 , I think what you need to do is concatenate. Let me know if this is what you are looking for?

1. Create an additonal Calculated Column using the code :

Division = FORMAT( [Total Cost] , "0,###" ) & "/" & FORMAT( [Cost] , "0,###" )

[ajaybabuinturi · Accepted solution]

Hi @ACraig08,
You need to modify the calculated field so that it calculates the ratio at the aggregate level, not summing the row-level percentages.
Instead of using a calculated column, you should use a DAX measure

% of Cost = DIVIDE(SUM('Table'[Total Cost]), SUM('Table'[Cost]))

Please let me know if you have any questions.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.