In the attached workbook, I want to total my Quantity measure across the table, but I don't want to show the Quantity subtotals down the table.
In Sheet 1, I have row grand totals turned on and I'm showing subtotals. I'd prefer to use the measure values as I am here, I simply want to remove the Quantity subtotals that are being displayed down the table.
In Sheet 2, I've right clicked the Quantity pill in measure values and chose 'Total Using - Hide'. This effectively removes the Quantity subtotals down the table (good), but it also removes the Quantity grand totals across the table (bad) - I want to keep these.
In Sheet 3, I've come up with a less than desirable workaround by using a discrete WINDOW_SUM calc to insert the totals across the table. I'd really prefer to have the grand totals display at the right side of the table.
Are there any other ways for getting the desired result?
This may not be as simple a solution as you are looking for, but I believe you can get the desired effect by essentially creating a separate worksheet for the WINDOW_SUM grand totals and display the two worksheets side by side on a dashboard. See this Knowledge Base article: Moving Grand Totals and Subtotals | Tableau Software