Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Brain freeze here! How do I find and mark the Max for each Dim1? How do I reduce the scope?
=if(Sum(Measure)=Max(Aggr(Sum(Measure),Dim1,Dim2)),'Max')
This
=if(Sum(Measure)=Max(TOTAL <Dim1>Aggr(Sum(Measure),Dim1,Dim2)),'Max')
This
=if(Sum(Measure)=Max(TOTAL <Dim1>Aggr(Sum(Measure),Dim1,Dim2)),'Max')
Thanks Sunny