3 Replies Latest reply on May 17, 2018 8:31 PM by Zhouyi Zhang

    How to calculate value for parent

    Youwei Chen

      I have data that list value for leaf node, and nested child/parent relation.

       

      In example below, 1 is root, with 2 and 5 as direct child.  2 has children of it own.

       

      I want to calculate derived value for each id.  Can this be done in tableau?

       

        Data:

      IDValueParent
      1
      21
      3102
      4102
      5151

       

      Result:

      IDValue
      135
      220
      310
      410
      515

       

      Thanks,