Could you please attach your data as twbx?
This excel seems like the view results and not look like tableau oriented data source.
Herewith attached a tableau workbook.
When I select Category 1 both Revenue and Sales will be displayed on the dashboard
When I select Category 2 only Sales will be displayed and REVENUE wont be present .. I want the SALES to occupy on the top and no blank should be present .
Basically the layout container should collapse for Revenue and only Sales should be displayed (occupy the top portion )
Kindly help me.
Reports.twbx 24.7 KB