what is the script to get three charts

[sonysree88]

Hi All,

I have 4 fileds

Date, Sal, Country.

in the country i have three countries: India, UK, US .

Question:

If i can select the US, US related chart and sales and date should display , if i can select UK---UK related chart and rest of the fields should display in that chart and same for India.

How can we achieve this and what is script for it in the data model.

what is the association on them..

This is interview question i have faced recently.

Regards,

Sonysree

[prieper]

Give it a try with two expressions:
SUM(YourValue)
SUM({<Country = e(Country)>} YourValue)

The first one should deliver the result only for the selected country,
the second all excluded the seleected country.

HTH Peter

[sonysree88]

Thanks,

Its not working , Please suggest us with solution to get the dynamic selection , please tell me if i can have the number of countries how we can get.

If i can use E() i have to give the country field manually right.