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