3 Replies Latest reply on Jul 7, 2018 12:54 AM by Deepak Rai

    Dynamically Generate a List of Unique Subcategories and Produce Aggregated Data

    Amit Ragoobar

      Good day all,

       

      So as I have the attached workbook setup, tableau can generate a "Grande Total" calculation that simply find the total of all items in the respective column. What I'd like to happen, is to have Tableau produce a Row at the end that basically ignores the "Region" column, and instead shows the total broken down by Category.

       

      Basically, I'd like the last row(s) to look like the following:

       

      RegionCategoryAverage
      Grand TotalRural1
      Grand TotalSuburban2
      Grand TotalUrban3
      Grand TotalAll4

       

       

      Any and all assistance would be greatly appreciated.