Percentage of grand total

[Pepson]

I need help with calculating percentage of grand total instead of summarization.

Correct result would be ST/MT = 56,76 / 292,00 = 19,4% instead of 1617,6%.

Any ideas?

[Pepson]

Using measure isntead of column fixed the issue.

[deevaker]

Awesome. 

if the solution helps and your issue is resolved. please mark the post as resolved to motivate us.
Regards, 

Deevaker Goel
+91-9711975011

[deevaker]

Hi, 

Can you please confirm if the column in format section is doing sum. if yes you can use average

Also, The better option is to create a measure instead of column with below calculation