display value as of parent column total in table

[#1]

Hi,

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?

Thanks!

[ogster1974]

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.

[#3]

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?

[ogster1974]

Hi Tamas

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

Regards

Andy

Sent from my iPad