Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wanted to show top performing brands plus a specific brand (this brand should always be shown irrespective of performance).
For example:
Date | Brand | Sales |
01/06/2018 | A | 321,947.6 |
01/06/2018 | B | 291,309.5 |
01/06/2018 | C | 217,505.9 |
01/06/2018 | D | 187,026.8 |
01/06/2018 | E | 84,763.7 |
01/06/2018 | F | 79,457.4 |
01/06/2018 | G | 60,125.7 |
01/06/2018 | H | 44,367.7 |
01/06/2018 | X | 38,146.7 |
The user would enter the Top N brands to display using the input box.
Let's say the Top brands that should be displayed in the chart is 4.
The expected output in the chart is A, B, C, X (The brand X should always be included in the chart)
When the top brands to be displayed in the chart is 5 then the output should be A, B, C, D, X
Please help me with the suggestions.
Hi, you can use something like this
Sum ({<Brand = {"=Rank(Sum(Sales))<4"} + {X} >}Sales)
and change the "4" by a variable
Regards
Hi, you can use something like this
Sum ({<Brand = {"=Rank(Sum(Sales))<4"} + {X} >}Sales)
and change the "4" by a variable
Regards
Hi Hectormunoz,
Thanks for your quick help. The solution worked perfectly.