4 Replies Latest reply on Jul 2, 2016 1:32 PM by Shinichiro Murakami

    Sets and calculated fields

    lavanya koneru

      I have created sets for Top25,Top50,Top75  showing Top 25 sales regions.Now I need to use this set in calculated field to find total percentage of sales for each group Top25,Top50 etc.

      I am trying to use this formula

       

      SUM([Number of Sales]) for Top25

      /

      SUM({FIXED [DateMonth] : SUM([Number of Sales])})

      how to set this using sets created

      If (top25="In" then sum(number of sales)) is not working with sets.