Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Kwame
Contributor III
Contributor III

Default expression should change upon user selection

Hi guys!

My goal is to set the expression as the default value, but it should also change based on user selection.

This is what I tried, but it didn't work.

Sum({<Location *={'Africa'}>} Sales)

So basically the user needs to be able to get e.g. Sales from other continents by selecting from the location filter and if no selection is made, the expression should return sales for Africa.

1 Reply
Aditya_Chitale
Specialist
Specialist

if(getselectedcount(Location), Sum(Sales), Sum({<Location ={'Africa'}>} Sales) )

 

Regards,

Aditya