Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try an expression in your line chart like
=Sum( Aggr( If(Rank(Sum( Value)) <=3, Sum(Value)), Month, Customer))
edit: changed Aggr() dimension order.
Hi Fabio,
Can you please attach your qvw file?
Thanks,
MB
Try an expression in your line chart like
=Sum( Aggr( If(Rank(Sum( Value)) <=3, Sum(Value)), Month, Customer))
edit: changed Aggr() dimension order.
May be this:
Expression: =Sum(Aggr(If(Rank(Value, 0, 1) <= 3, Value), Month, Customer))