1 Reply Latest reply on Mar 8, 2016 6:44 AM by Justus Niemzok

    Grand Total Calculation in Tableau

    rohit puri

      Hi,

       

      I have a category and sub category. I want to calculate the grand total or average or median for the overall row of every category and show as an overall row for category. How is this possible in Tableau 9.2?

       

       

      Attribute

      C1

      C2C3

      C4

      C7

      C6

      C8

       

      Overall

      450

      45

      90.00%

      97.05%

      95.56%

      $5,625,721.70

      $170,634.90

      A

      250

      20

      92.00%

      98.18%

      95.26%

      $2,751,324.02

      $87,134.00

      AA1

      120

      12

      90.00%

      98.09%

      98.00%

      $1,516,256.00

      $47,269.00

      $10,198.00

      $52,379.47

      98.07%

      A2

      80

      4

      95.00%

      97.16%

      97.05%

      $751,089.20

      $15,435.67

      A3

      50

      4

      92.00%

      98.30%

      97.11%

      $501,913.00

      $25,169.70

      B

      75

      10

      86.66%

      97.09%

      97.40%

      $1,421,628.31

      $36,384.45