4 Replies Latest reply on Apr 26, 2018 6:47 AM by Shinichiro Murakami

    how to add have total of average columns in tableau

    Mohammed Junedi

      Hi,

      i have a request where i need to make the avg of column values and then Sum the avg column values to be a grand total / subtotal. I can do that by 'total all using - average' from the analysis tab from below link. but the problem which i am facing is the measures have to be selected in the filter. So i am using the measure names in the drop down filter when i deselect profit or Sales and re-select that column i dont get the values as avg nor total in sub total and Grand total. Any help or tip will be appreciated. I enclosed the workbook. I am trying to mimic my requirement using the sample data.

      Average column totals and Sum row totals in the same crosstab??

       

      Thanks in advance.