Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Sure.
This is how it looks like after removing suppression:
Many thanks for all help.
Exactly what i was suspecting. If you scroll down you can see a null value in dimension and it has the max value which is getting shown . so to ignore the null and to have 612091 as max in all rows use if(len(trim(Step_Nnull))>0,Step_Nnull) as dimension.
regards
Pradosh
or with suppress null
Max(TOTAL Aggr(Sum({< Step_Nnull ={"*"}>}[Customer Count]), Step_Nnull))
as expression
Thanks i get it now!
But for some reason the calculated dimension is not working though.
try the above expression with Step_Nnull as dimension and suppress null.
Wow. Saw your second reply and it works! Thank you very much.
Many thanks to Pradosh and Sunny!