0 Replies Latest reply on Jul 29, 2013 8:47 PM by Adrian Slade

    reposition column grand totals

    Adrian Slade

      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