Top Ranking

[vnachiap]

I'm trying to get Top 5 styles information for each division. Is there any help anyone could provide in achieving this.

Example

Division 1

               Style 1

               Style 2

               Style 3

               Style 4

               Style 5

Division 2

               Style 1

               Style 2

               Style 3

               Style 4

               Style 5

Thanks

[mdmukramali]

Dear Venkat,

Can you share sample data so that we can help you in better way.

Thanks,

Mukram.

[Anil_Babu_Samineni]

If you have Data points metric in your DM. You can try sommething like below

AGGR(IF(Rank(sum(Sales), 4)<=5, Style), Style, Division)