Max value from month

[dunnalahk123]

Hi,

in my table i have 1 dimension called month and in expression we have actual value for it.

but now in next column(Max Actual)  i have to populate maximum value out of all months . so  in my below table max actual column should give 92.4  for all months.  as 92.4 is the highest value. how can i write can any  one suggest me.

[sergio0592 · Accepted solution]

Hi,

Try with below formula. Should works

max(TOTAL Actual)

[dunnalahk123]

Thank You Sergio . it works