We may need to create separate sheets for the headers and combine all 3 sheets on one dashboard.
1. Create the calculated fields "Header 1" and "Header 2".
2. Create separate sheets for each header and place the calculated fields on the Marks card on Text.
3. Combine all the views in a Dashboard.
I have attached a copy of the workbook with my work.
As an alternative, if the dimensions are related, it may be worth looking into pivoting.
Hope it helps!
Workbook Sample.twbx 16.1 KB