4 Replies Latest reply: Jul 7, 2014 3:39 AM by Дмитрий Кудревич RSS

    ABC marks by accumulation condition in table

      Hi. Need experienced and wise adviser.

      I have 3 indicators by date.

      I have to mark each by letter by condition.

       

      A:     <= 20%*,

      B:     >20% and <=80%*

      C:      >80%*

      * - accumulation sum sorted by value

       

      I have this:

       

      PremiumRevenueAmountDateMonthProduct
      2005000506.01.20141Product6
      2001000706.01.20141Product7
      23515501507.01.20141Product4
      2358000207.01.20141Product5
      235300107.01.20141Product7
      5507701501.01.20141Product9
      155030001402.01.20141Product10
      220010000106.01.20141Product9
      253512150207.01.20141Product8

       

      And I need this:

       

      PremiumABC PremiumRevenueABC RevenueAmountABC AmountMonthProduct
      235C1550C15B1Product4
      550C770C16A1Product9
      1550B3000C14B1Product10
      200C1000C7C1Product7
      200C5000C5C1Product6
      2535A12150A2C1Product8
      235C8000B2C1Product5
      2200B10000B1C1Product9
      235C300C1C1Product7

       

      Have any ideas???