Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to show top 4 in line chart.. where my dimension is Month & Competitor.. YTD, QTD wise on selection.
For e.g :
Month | Name | Value |
Apr | A | 100 |
May | A | 200 |
Jun | A | 102 |
Jul | A | 120 |
Aug | A | 140 |
Sep | A | 130 |
Oct | A | 80 |
Apr | B | 150 |
May | B | 300 |
Jun | B | 105 |
Jul | B | 120 |
Aug | B | 150 |
Sep | B | 230 |
Oct | B | 180 |
Apr | C | 200 |
May | C | 400 |
Jun | C | 360 |
Jul | C | 120 |
Aug | C | 520 |
Sep | C | 230 |
Oct | C | 165 |
Line Chart has two dimension Month & Name.
Expresssion is : Sum (Value ) / Sum (total Value)
For A will be : 100/450 as the % in the chart..and same for others.
Now I want YTD i.e if I select Jun then it should give for A
Sum of value for A 402 and total value is 1917...
On the basis of YTD, QTD i want top 2...
Are you looking for top 2 or top 4?
Also, assuming you are looking for top 2, are you looking for top 2 names?
Top 2 names..
I am still not sure what you are looking to get, but may be this