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