I have a dimension Step and expression - Unique Customer (sum([Customer Count])). i want to create max of Unique Customer but unable to do so with max(sum([Customer Count])). How do i get the results as shown below?
Would you be able to post screenshots without label names and extended columns so that I can see what expressions you are using? Also, Step is the only dimension in this chart? or are there more then that?
Sure. Below is the screenshot excluding label. Also, Step is the only dimension in this chart and i did suppress when it is null value. Third column will be Max(TOTAL Aggr(Sum([Customer Count]), Step_Nnull))
Thanks for your help.
i think it is showing the correct data. is there any null value in step_Nnull field. My guess is you have null and the Sum([Customer Count]) for that is 506,014,721
try to uncheck suppress null from dimension and use these expression. share the screenshot after that. null should not be suppressed.
Max(TOTAL Aggr(Sum([Customer Count]), Step))