5 Replies Latest reply on Nov 6, 2015 6:22 AM by Junhe Yang

    Percentage calculation within a dimension

    Junhe Yang

      Hello community,

       

      I have a data structure like below:

       

      IndicatorValueYear
      A11990
      B21990
      C31990
      D41990
      A51991
      B61991
      C71991
      D81991
      A91992
      B101992
      C111992
      D121992

       


      In tableau I would like to calculate the result of A/B over all years., i.e. 1990, 1991 and 1992. So that for 1990, the result will be 1/2 = 50%, for 1991, the result is 5/6, and for 1992, the result will be 9/10=90%.


      I tried with table calculation but it seems hard to get the desired result. Could anyone help with this tricky problem? Many thanks in advance. A sample tableau file attached.


      June