3 Replies Latest reply on Aug 3, 2016 9:47 PM by Mahfooj Khan

    Grand total row: cannot change "Total Using" from Automatic to Average

    Kaitlin Lockhart

      I have a table with many columns and I have no problem changing how their Grand Totals are displayed. For three specific columns, however, I am getting strange results and I can't figure out how to change how Tableau is calculating it.

       

      1.png

      2.png

       

      The options to change the calculation are disabled. These three columns come from another data source than the rest of the table, so I'm wondering if that has something to do with it? I want the grand total to display the average of these percentages. I don't know why the result is so small.