Top 3 Chart - Aggr + Rank + Set Analysis

[#1]

Gents,

I'm struggling in create a new line chart with my "top 3" ranking data.

My goal is figure out the top "3" customers for each period and plot in a chart, as the picture below.

I think I'm closer to the solution using Aggr+Rank, but my results does not match yet. Any clue in the final expression?

Thanks in advance.

[miguelbraga]

Hi Fabio,

Can you please attach your qvw file?

Thanks,

MB

[swuehl · Accepted solution]

Try an expression in your line chart like

=Sum( Aggr( If(Rank(Sum( Value)) <=3, Sum(Value)),  Month, Customer))

edit: changed Aggr() dimension order.

[sunny_talwar]

May be this:

Expression: =Sum(Aggr(If(Rank(Value, 0, 1) <= 3, Value), Month, Customer))