I have a table with 2 columns, one dimension and one measure.
I'd like to display the values of the measure column in % of the column total instead of absolute values.
Can you please help?
This should do it. You just need to use Total in your Sum of value to bring through total value. From there it is straightforward to derive the percentage. See attached.
Andy, thanks a lot!
is there any way that I can have the % as the second column? Alternatively, can I hide the two columns before (Value by Country, Total Value) used for the calculation?
You can remove the other columns if you want I just added them so you could see how the calculation was built. Please mark the question as answered if this has been useful
Sent from my iPad
Retrieving data ...