Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Do You have Country as Dimension in Your chart?
Hi am not using any chart, i have to shoq all those information in a text box
Thanks,
But that is not what exactly i want, i want all those information in a text box
Can you show us that textbox and expected output.
May be like:
Use Implicit set expression like: Sum({<Country*={'India'}>}Sales)
I don't think it is possible to show in the text box the way you want.
try this, could be an solution:
=concat(Country,' ')& chr(10) & concat(Sales,' ')
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 |
Thanks