To show Month wise Top 5 product values in combo chart

[janardhan]

Hi All ,

I'm creating a combo chart , i want to show Month wise top 5 product values.

Please can anyone help on this. Thanks in Advance.

Thanks,

Janardhan

[Vegar · Accepted solution]

Try to create a combo diagram using month or YearMonth as a dimension and use an expression similar to the one below:

=SUM({<Product= {"=Rank(sum(Amount))<=5"}>} [Amount])

[janardhan]

Thanks for your help...