6 Replies Latest reply on Nov 20, 2017 8:34 AM by Julio Moyano

    How do I create a calculated field with dimension filter

    Julio Moyano

      Hi everybody,

      I need to create a calculated field with dimension filter, and when I choose some  variables in the dimension "variable" my SCORE M should change.


      SCORE M is my calculated field

      I have this data where "variable" is a dimension and "score" is a measure


      variable  score

      X              2

      Y              3

      Z              2


      My calculated field (SCORE M) is X * Y * Z =12, but I would like to choose some variables, for instance: If I choose the variable X and Y then my SCORE M will be 6, because X * Y = 6


      (I have a many variable and I need the SCORE M changing automatically every time when I will choose some variables)



      Somebody can help me



      Thank you