2 Replies Latest reply on Jan 4, 2011 10:46 PM by Joe Mako

    How to create running sum with partioning

    . Chen

      Hello,

      The attached file contains data about product inventory transactions. for each year and period (same as month), I have a number of transactions, and I want to see the movement across each product. i.e. if period 1 in 1992 is 3 and period 2 is -1 then the running sum would be 2. The running number should restart with every product.

      I read the documentation, but did not understand how to do that. I could get it to run on the all column, or on each cell, but not to restart every new product.

      Any help would be appricaited.

      Thanks,

      Chen Hirsh