How to show top 2 Ytd wise.. with 2 dimension..

[kavita25]

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...

[sunny_talwar]

Are you looking for top 2 or top 4?

Also, assuming you are looking for top 2, are you looking for top 2 names?

[kavita25]

Top 2 names..

[sunny_talwar]

I am still not sure what you are looking to get, but may be this