2 Replies Latest reply on Oct 18, 2012 11:34 AM by . Marellano

    How to change the GRAND TOTAL to aggregate as as different measure

    . Marellano

      Hello Tableau Forum,


      I have a simple bar chart measuring the "Average $", year-over-year for 3 Auto Loan categories (please view attached image).  The Grand Total automatically averages all 3 categories as well.  However, I like the Grand Total to measure by the SUM of all the Averages. 


      For example, the chart shows the following "averages" for total $ in 2010:


      Other Auto:                                   3.6M

      New Auto:                                   13.4M

      Used Auto:                                  25.5M


      Grand Tot:                                   14.2M


      Grand Tot (as sum of avg):              42.5M


      I tried playing with some table calculations to no avail. 


      Thank you in advance,