1 Reply Latest reply on Sep 9, 2018 7:52 PM by Zhouyi Zhang

    Calculated field  - keep existing dimensions

    James Versteegen

      Hello all, I am attempting to add a calculated field but want to keep the existing fields.

      The calc is based on specific elements within the dimension, however I still want to display the elements I am using

       

      eg.

       

      Element     Value

       

      AAA          2

      BBB          3    

      CCC          2

      DDD          4

      EEE          6

       

      add a new field which combines BBB, CCC and DDD.

       

      Let's call it FFF

       

      So output would be

       

       

      AAA          2

      BBB          3    

      CCC          2

      DDD          4

      EEE           6

      FFF          9

       

       

      I want all fields to appear in the same dimension.