4 Replies Latest reply: Mar 9, 2018 4:14 AM by nagamani vadisala RSS

    Need to do buckting and Cummulative on top of it

    nagamani vadisala

      HI

      I have only one column "data" as below.

      data

      0

      2

      10

      20

      30

      100

      110

      200

      I need to create bucketon this as,

      <0

      0-10

      10-100

      100 - 200

      and i need to get cummaltive sum of data based on this bucketing

      Bucket            Cummulative sum

      <0                               0

      0-10                            12

      10-100                        162

      100 - 200                    472

      Can anyone please suggest on this