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



      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