Ceeate a calculated field Departure = Destination, add to Filters shelf and filter for False.
Hi Lan Low,
Just create a calculated Field (Alt + A +C)
Option A=Option B,
drag calculation to Filter shelf, Edit filter and tick on False .
Please mark if it address your query.
Hi, unfortunately that wouldn't work.
In the data set - no one would be flying from Indonesia to Indonesia for example.
What I am looking it is for eg. I am looking a population in South East Asia and I want to see all the people Leaving South East Asian to countries outside of the region (meaning excluding those who are departing and landing within South East Asia's set of countries).
If you look at the extract i came and in Sheet 1. I've already filtered Option A to Options 1, 2 & 3. I want to Exclude Options 1, 2, 3 and Option B (meaning they should not appear at all in any of the relevant values)...