Tableau is putting all the column grand totals at the end, but I want them in their respective sections.
Columns: Measure Names pill, Region pill
Rows: GSL Description pill
Marks: Measure Values pill
Measure Values: SUM(Number of Records), SUM(Amount)
So basically there are 2 sections -- Number or Records & Amount. In each section there are 6 regions. This gives me 13 columns, calling the Row headers as column 1.
I add the Column Grand Total & it put a Total for the Number of Records & a Total for the Amount at the far most right columns 14 & 15 respectively.
I want the Total for the Number of Records at the end of it's section column 8. And the total for the Amount at the end of it's section column 15.
How can I achieve this?
Thank you in advance
Retrieving data ...