0 Replies Latest reply: Sep 2, 2015 10:34 AM by kitty Lee RSS

    Opening and Closing

      Hi,

       

      I have data like:

      Tx               Type     Qty

      2013/1/1        In          30 pcs

      2013/3/1     Out          -5 pcs

      2014/1/28     In            10 pcs

      2014/5/20     Out          -13 pcs

      2015/1/4       In          8 pcs

      2015/4/6     Out          -7 pcs

      I would like to build a chart to show movement in Qty to see the closing trend.

                     Opening          In               Out               Closing

      2013          0                   30               -5               25

      2014          25                10               -13               22

      2015          22               8                    -7               23

       

      Can anyone help me to fill-in below ........in set analysis

      Sum({<Year=,Month=,Quarter=,..............>} InQty) - Sum({<Year=,Month=,Quarter=,....................>} OutQty)