1 Reply Latest reply on Dec 31, 2013 10:06 AM by Peter Gilks

    How can I group my information by quartiles?

    Jesús Ramírez

      How can I group my information by quartiles?

      I have many detailed transactions and I need to assign the quartile value to each one; after that, I need to compare quartile past year vs current year.

      Example:

       

      Date

      CVES

      FRACC

      NUMPMENTO

      PATADUANAL

      SECCIAFRAC

      Precio Unitario Partida (SUMA)

      Volumen UMT (SUMA)

      QUARTIL

      ene-11

      300

      64011001

      1000001

      3584

      2

      1. 185.6484848

      825

      Q4

      ene-11

      240

      64019201

      1000004

      3631

      22

      1. 377.640625

      64

      Q0

       

      I need to re-group this information by quartil and make a comparison.

      Regards,