Here is the steps:
(1) Pivot the Data Source.
(2)Make a calculated field: Empty Rows:
SUM([Pivot Field Values])<1
Put in filter, choose "False".
Please see screen shot and workbook.
Hope it helps.
Tableau Remove Row help2.twbx 31.4 KB
The data source that I'm trying to replicate this on is using a Custom SQL Query. How would I pivot the data this way?
There are many resources to discuss how to pivot using SQL. Here are some: