9 Replies Latest reply on Apr 21, 2017 7:35 AM by Prayson Wilfred Daniel

    Calucate based on specifc group of values within a Dimension

    Bill W

      Morning,

       

      I am trying to create a calculation in order to only calculate values within a specific team.

       

      Example, trying to calculation only values within the 'Team' dimension and only B and D to receive a total of 26.

       

      I tried to use a Set, but received an error. If [TeamSet] = "True" then [Amount] end

       

      Any thoughts would be greatly appreciated.

       

      Update -

      Sorry, I forgot to add an extra element. I need to do a count distinct of IDs associated with those teams as well.

       

      So it'd be an amount of 26 and an ID count total of 5

       

       

      -Bill