Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try this expression
FirstSortedValue(Category, -aggr(max(aggr(Count(PCODE),CustomerID,Category)),CustomerID,Category))
Hi
Try this expression
FirstSortedValue(Category, -aggr(max(aggr(Count(PCODE),CustomerID,Category)),CustomerID,Category))
Hi Mohan,
Did it work ?
Hi Scotly,
Yeah !! It works Thanks for your head up..!!