Hey all, I have a set of shipping data that has load countries and discharge countries, the two groups have the same list of countries in it. I have created a parameter, 'Country', and know how to add the 'load country' filter to the shelf and base it on a formula '[load country]' = [Country], so when the user selects a country on the dashboard it selects that as the load country.
I want them to be able to view export data, so on top of selecting the correct load country, it then to select the discharge country as all countries but exclude the country I selected (IE if I wanted to see Italy export data the filter is load country = Italy, discharge country = All excluding Italy) I cant seem to work out the formula to do this
Its also live data so I cant extract it
Any ideas?
Thanks, Tom
Hi Thomas,
If load country and discharge country come from 2 different fields then check for that as well in the calculated field
[Load Country]=[Country] and [Discharge Country]!=[Country]
Add this to the filter and set it to 'True'
