Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])
Thanks for your help...