I have a data set that look like this:
As you can see some ABNs have multiple business names attached while others have just one.
I want to create a filter that allows the user to see just those rows where there are multiple names to each ABN.
For example, a filer that will filter out ABN 456.
I can imagine how I would write that in SQL, but cant get my head around how to do it in Tableau.
Any help would be appreciated.
This should be doable if you do a Filter on ABN and then go to the condition tab. Then select by Field and do Business Name - Count or Countd > 1