Bar chart conditions for ranking

[#1]

Hi,

i have the counties data on x axis and sales on yaxis .

requirement is retrieving the sales data whose rank is less than particular country.

suppose display countries sales whose rank less than 'india'.

pls helpme asap where to write condition and what to write

regards

mahesh t

[MayilVahanan]

Hi

Can you provide me a sample file?

may be try like this , not sure...

=If(Rank(Sum(Sales)) < Rank(Sum({<Country = {'India'}>}Sales)), Sum(Sales))

[#3]

Thank u so much

[#4]

Ok but i am getting erros can pleas try again fo rme >> check the operator once these thing i am new to set analysis

[MayilVahanan]

hi

can you post a sample?