10 Replies Latest reply on Feb 17, 2015 12:55 PM by Matt Lutton

    Grand Total Manipulation

    Tirupati Srivastava

      Hey Everyone,

       

      I know that Tableau while doing a grand total (from Analysis --> Totals) excludes the row level grouping and operates on data as a whole.

      I am doing an average cost per ID and when doing the Grand total,  its giving the wrong total (Please see attached workbook).

       

      Please help me get the correct Grand Total. I want 369 as the total instead of 61.27 as derived in the workbook.

       

      Please help and advise

       

      Thanks

      Tiru