How we can achieve by using alternative state

[#1]

Hi,

I need to list the top 3 countries whose sales greater than sales of USA,here USA is selected from list box.Suppose if we select UK I need to display 3 countries whose sales greater than sales of UK....and so on.

List box contains 50 countries.

how we can achieve this output by using alternate state instead of set analysis.

Thanks

Swathi

[lironbaram]

hi

have a look at the attach example

[#3]

Oh unfortunately I am unable to open the qvw because I have personal edition in my desktop.Can you please share explanation here??

Thanks Swathi

[lironbaram · Accepted solution]

yes

ok after loading the data

i created a list box and assigned it to alternate state

in this list box i allow only one selected value

the value in this list box is the reference country.

i than created a variable named vRefernceSale with this formula

=sum({Alternate1}Sales)

than in a straight table i chose country as the dimension

and used this expression

if(sum(Sales)>vRefernceSale,sum(Sales))

the last step is to define in the dimension limit

show 3 largest values

[#5]

Thanku Liron