5 Replies Latest reply: Mar 21, 2014 9:03 AM by Nicole Smith RSS

    Count largest

      Hello,

       

      I would like to count how many largest value give 80% from all from subcategory.

       

      Below I have a date sample :

       

      NameCategorySubcategoryP1
      AZZZOther60,00
      BZZZOther 140,00
      CXXXOther 280,00
      DXXXOther 190,00
      EZZZOther 2

      95,00

      FXXXOther 360,00
      GZZZOther 170,00
      HXXXOther 480,00
      IZZZOther 190,00
      JXXXOther100,00

       

       

      Sum by category

      Other160,00
      Other 1290,00
      Other 2175,00
      Other 360,00
      Other 480,00

       

      Max 1 form "Other" = 100

      Max 2 form "Other" = 60

       

      Other :
      Count largest which give over 80% = 2  because ( 160*0,8=128 < 100 and 60 )

       

      Other 1 :

      290 *0,8 = 232
      Count .. = 3 ( 90 , 70 , 90 ) because  232 =< 250 ( 90+70+90)

       

      If someone could help I would be grateful !!