How to get the max of dimension?

[mohan_1105]

Hi,

I am using a straight table, in which I wanted to show the highest repeated category from my Item table. Data looks as follows,

From the above table, I need a straight table as follows,

Please help me to figure it out !!

Thanks,

Mohan

[scotly-victor · Accepted solution]

Hi

Try this expression

FirstSortedValue(Category, -aggr(max(aggr(Count(PCODE),CustomerID,Category)),CustomerID,Category))

[scotly-victor]

Hi Mohan,

Did it work ?

[mohan_1105]

Hi Scotly,

Yeah !! It works Thanks for your head up..!!