Easy way to get 15 free YouTube views, likes and subscribers
Get Free YouTube Subscribers, Views and Likes

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

Follow
Techi Anshi

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 [SubCategory]
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

posted by guiaculcu