Filter base Selection

[nisha_rai]

Hi,

I have to show sum of sales for particular location,but if we select other location it should show Zero.

For example:

Country Sales

India 200

US 300

UK 100

Result : when no filter select from Country

India = 200 US = 300 UK =100  /// I am using set analysis for that

If we select India from Country List box

India = 200 US =0 UK =0 // Set analysis is not working it show India=200 US =300 UK =100

Please suggest me how to solve that to retrive the result.

Regards,

Nisha

[nisha_rai]

Hi Pooja,

I tried this in text box if(Getselectedcount(Country)=0 or if(match(Getcurrentselections(Country),'Inida'),1),1,0)

but it's doesn't give me result when i m selecting two country at a time

[stabben23]

Do You have Country as Dimension in Your chart?

[nisha_rai]

Hi am not using any chart, i have to shoq all those information in a text box

[nisha_rai]

Thanks,

But that is not what exactly i want, i want all those information in a text box

[stabben23]

Can you show us that textbox and expected output.

[tresesco · Accepted solution]

May be like:

Use Implicit set expression like:  Sum({<Country*={'India'}>}Sales)

[trdandamudi]

I don't think it is possible to show in the text box the way you want.

[stabben23]

try this, could be an solution:

=concat(Country,' ')& chr(10) & concat(Sales,' ')

[nisha_rai]

Hi

India	US	UK
200	300	100

all are text box,when their is no selection we have filter as a country

when we select any Country such as India and UK then

India	US	UK
200	300	0

[nisha_rai]

Thanks