selection filter ?

[#1]

HI All,

If i select USA, I want to see Sum, Max, Min Expressions.....

If i select UK, I want to see Count, avg, Max Expressions.....

If i select Ireland, I want to see Count, avg, Min Expressions.....

If i didn't select any CustomerCountry I want see all the expressions...

Kindly help me on this..

Regards,

Helen

[tresesco]

Enable expression conditional check box and use expression something like:

for count expression = WildMatch( Concat(DISTINCT CustomerCountry&'|'),'*UK'&'|*','*Ireland'&'|*')

PFA

[Anonymous]

Do you want the effect only for 3 countries?? or for all the countries in your list??

Try using conditional expressions.

table properties - expressions - click on expression - check conditional - and writhe condition like getfieldselections(country) = USA or getselectionscount(country) = 0 for sum,  and similarly  getfieldselections(country) = UK or getfieldselections(country) = IRELAND or getselectionscount(country) = 0 for count etc.

Think this will work but lets see if there is any better way.

[pipuindia99]

Hi,

PFA,

It works for me as required.

[pipuindia99]

sorry attached wrong file earlier, attached now the correct file.

[sunny_talwar]

Did you even try this?

Selection of Countries ?