2 Replies Latest reply: Jan 31, 2016 10:20 AM by Anna Perini RSS

    How to create ranges

    Anna Perini

      Hi, i've an excel table like this:

       

      customerprod aprod bprod cprod d
      a100320
      b1200000
      c2008003001000
      d502340051
      e2325500
      f11445611

       

      i need to create in my frontend some ranges: how many customers have

      • 0-500
      • 501-1000
      • 1001-2000

      for each product. My output should be:

       

      rangeproduct aproduct bproduct cproduct d
      0-5006465
      501-10000101
      1001-2000 0100

      Can you help me?

      Tks