Dynamic Bar chart based on list box input values

[#1]

Hi,

I have the requirement like countries in x-axis and sum(sales) in y axis.

i have list box contains 30 countries,

Requirement is like this:

list the top 4 countries whose sales greater than sales of 'india'.Here 'india' is selected from list box item.

suppose i select 'UK' from list box items.Let me know how to proceed for solution.input data must be from list box.

regards

Mahesh

[Nicole-Smith]

See the attached example.  Make sure to look at the Dimensions, Dimension Limits, and Expression tabs of the bar chart.

[#3]

Find the solution in attached qvw.

Though there may be many others ways, I have used Alternate states.

Regards,
Prabhu

[#4]

U can use the below expression..

=if(Sum(Sales) >Sum({1<Field={"$(=getfieldselections(Field))"}>} Sales),Sum(Sales))

Regards,

Kabilan K.