Create a calculation like below
Only City having all values:
and Add it to Filter and Select False
You will get the final O/P
Hope this helps
Plz mark this answer as correct or helpful to close the thread
Thanks Naveen for your prompt repsonse! Works perfect!
I thought it would solve my problem. However, I just noted there is a difference in the source data to the example I have provided and the working file I have.
In the example I mentioned the zero values lanes as well. Whereas in my data source these are not available. Therefore, I guess it would not work in my working file with the actual real live data.
See attached the new example with the new workbook. Hope you can help solving this. Sorry for the inconvenience.
Test file - tableau.twbx 14.9 KB