How to Create Accordion Table in Tableau | Expanding & Collapsing Table using Arrows in Tableau

This video will enable you to create a Table which can expand and collapse using the Arrow buttons, where you can see the Categories and Subcategories in the same view as you would like

For this you will need a few calculations I am listing them down here for your reference:
1) Arrow Calculation
IF [Table Name]= "Orders"
AND NOT [Category Set]
THEN "▶"
ELSEIF [Table Name]="Orders"
AND [Category Set]
THEN "▼"
ELSE ""
END

2) Category/SubCategory
IF [Table Name]="Orders1" THEN [Sub-Category]
ELSE [Category]
END

3) Filter
[Table Name]="Orders" OR [Category Set]

Please let me know your thoughts on this video and some future video suggestions

Connect with me on Linkedin, Twitter, Instagram https://linktr.ee/techianshi

Happy Learning!!
Do not forget to #subscribe #like #share #comment #pressthebellicon