Hello,
I need some help on filters.
My data model contains 35 countries and has two different values such as Sales and spends all countries have Sales but only few countries have spends data.So when I enter into the Spend related data sheet the country with spends should be active and other countries should be grated out.
I tired triggers like Onactive Spend >=0 and it works for me but it is populating in Current selection filed and if try to clear it all countries are active again.
Could some one help me to resolve it.
