Finding Max

[luismadriz]

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')

[sunny_talwar · Accepted solution]

‌This

=if(Sum(Measure)=Max(TOTAL <Dim1>Aggr(Sum(Measure),Dim1,Dim2)),'Max')

[luismadriz]

Thanks Sunny