Hi Community,
I am creating a table in Tableau Desktop but there are many rows in blank.
First I have started with an output from Prep where all the information is in columns (Entity, Department, Month and all the different tasks).
Then, In Tableau Desktop, I have moved Entity to columns and I have moved some tasks to rows. Also, I filtered by month. For the moment, everything is fine.
The problem comes when I move Department to rows. It duplicates the tasks for all the departments even if some tasks do not apply to other departments and the information is null.
How can I remove or hide these blank rows?
Thank you!
Hi @Pahola Diaz
I have tried this but it did not work.
I have created the calculated field based on the values I have now:
And then, when I move the calculated field to filters I get this. If I select False it show everything and if I unselect False it shows the page in blank,
