7 Replies Latest reply: Apr 23, 2014 2:51 PM by Darius Pranskus RSS

    Calculate Average Dimensions

    Kinjal Shah

      I have a table as below

      DateProduct%low sales
      01/01/01abc95
      01/02/01abc97
      01/03/01abc98
      01/04/01bcd85
      01/01/01bcd80
      01/02/01bcd65
      01/03/01bcd70

       

      I want to create a chart that will take an avg of low sales and categories them as high performance and low performance based on avg % low sales and give me a product count

      So, eg. if avg(%low sales) >95, low performance, high performance)

      I cannot seem to get avg calculation working in the Dimension to create these categories to classify my product as low or  high... Please help.