Subtract dimension average from max value in table

[PaulH1]

Hello,

I'd like to write an expression within a table that subtracts the MARKET RATE in each row from the best MARKET RATE. So in the example below the maximum is Italy at 90% for ID 2 so all other values in the Difference column are subtracted from 90%.

Thank you.

[dplr-rn]

i dont know what your data is like but assuming rate isnt aggregated in any way

define difference like so Max(total Rate)- Rate

[blueran]

or instead of total use {1} which ignores all selections

[PriyankaShivhare]

Max(Total<ID> Rate)-Rate

[pradosh_thakur]

If you want the max from all the ids then Max(Total RATE)-RATE

If you want for some specific dimension then Max(Total <dimesnion> RATE)-RATE for ex. Max(Total<ID> RATE)-RATE

-Pradosh