14 Replies Latest reply on Jul 8, 2013 10:18 AM by Jonathan Drummey

    I'm pretty confused about the whole subtotal/total thing...

    Chad Kovac

      When I have subtotals turned on, I get some really strange results.

      I've read the forum posts about how to set up a TOTAL instead of an AVERAGE for grand totals, etc., but to be honest, that seems like a seriously convoluted messy hack.  Why is there no option to just set the column totals to what we want?

       

      Anyway... someone please explain why I see these:

       

      Capture2.PNG

      In Excel, the last column should be 862,811.  If it was an average it would be 66,730.  No idea where 5 million comes from. - this is the per-record level of data.

      Capture.PNG

      Same thing here...   different tableau workbook, different data... same wonky result.  Not an average or a total.