6 Replies Latest reply on Mar 15, 2018 8:09 PM by venkat pondugula

    Create sub total for metric of multi measures

    venkat pondugula

      I have created table in tableau, which has Metric, State, Sub state and Measure. I need the sub total Metric level for Measures.

       

      Attached is the tableau and excel data. Below is the format which i need same in tableau.

      Please help me on this.

       

      MetricStateSub StateMeasuresSum of Values2
      M1AaPremises10
      SAM3
      aaPremises50
      SAM7
      BbPremises20
      SAM5
      CcPremises30
      SAM7
      DdPremises40
      SAM2
      ddPremises70
      SAM8
      M1 TotalPremises220
      SAM32
      M2AaPremises20
      SAM10
      aaPremises30
      SAM10
      BbPremises100
      SAM5
      CcPremises30
      SAM6
      DdPremises70
      SAM2
      ddPremises20
      SAM3
      M2 TotalPremises270
      SAM36
      M3AaPremises50
      SAM10
      aaPremises30
      SAM4
      BbPremises100
      SAM20
      CcPremises200
      SAM7
      DdPremises60
      SAM6
      ddPremises20
      SAM2
      M3 TotalPremises460
      SAM49
      Grand TotalPremises950
      SAM117