I have a dataset (excel) where the first 2 columns are filters for the third column which contains row labels.
|Demographics||Age||13 to 18|
|Demographics||Age||19 to 29|
|Demographics||Age||30 to 49|
A viewer can select Demographics from the MainGroup filter, and see all rows grouped by SubGroup, or use a second filter to only show the rows from a specific SubGroup.
I also have a row header called "Total", that I would like to include everywhere. Meaning it is always included regardless of which selection is made in Main Group or SubGroup.
I've got the total row in the same format as the table above, like this:
Is there a way to ALWAYS include MainGroup = Total & SubGroup = Total PLUS whatever a user has selected as a filter from MainGroup and SubGroup?
I can think of a few things I would like to try, but I'm not completely sure of your data and your goal. Can you attach a sample packaged workbook (.twbx) showing what you have, and documenting clearly what you want to see? If you have confidential data, please see Anonymize your Tableau Package Data for Sharing |Tableau Support Community.