Have you considered a new calculation for a string field for counting purposes?- Min([origin],[destination] + max([origin],destination]
it will create a concatenated field where it origin / destination pair are in alphabetical order
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
simple question but required some workaround... without creating table alias and reverse the function or reverse the source and destination you can't achieve this.... some examples below with data
Origin Destination BOOKING string2 LHR CDG 22 CDGLHR CDG LHR 33 LHRCDG ABC DEF 99 DEFABC DEF ABC 99
before taking data into tableau you should write query to get your designed output in sql and then get the data that would be more easy to resolve this as it require joins and reverse of source and destination logic.... i should have solved but need some time time to get complete.... try with this information and see if you think from here to solve the issue....