need help in getting sum(sales) of top 5 and top 10 customers Monthwise on bar chart

[sudhanshu123]

Hi ALL

need help in getting sum(sales) of top 3 and top 2 customers Monthwise on bar chart.

Have data like

Sales Customers     Month

10      Rag Limitd      Jan

30     Rag Limited    Feb

47     Part Finance   March

68     Pany Auto     April

78     Part Finace    May

30     Rag Limited    Feb

47     Part Finance   March

68     Pany Auto     April

78     Part Finace    May

68     Pany Auto     April

78     Part Finace    May

30     Rag Limited    Feb

Please Help

Thanks Sudhanshu shrivas

[Chanty4u]

try this exp

Dim:Month

Exp: =aggr(if(rank(sum([Sales]))<=3,customers),Customers)

[Anonymous]

Please check below app for you Question

[benjamins]

I'd say your sample data is insufficient, as each Month only has one customer.

That being said, you need to assign a rank to each of the Customers per Month, as in attached sample (all done in skript).

You can then proceed to only Display the desired customers.