8 Replies Latest reply: May 26, 2011 3:45 AM by Kaushik Solanki RSS

    how to aggregate data using dynamic set of selection

    Chandan Chakraborty

      Hi Friends,

      I want to calculate month wise opening balance from the following table.

       

      Product       Day            Qty      Tag

      1                 01/04/2010  20       O

      2                 01/04/2010  25       O

      3                 01/04/2010  10       O

      1                 01/04/2010  51       T

      2                 01/04/2010  50       T   

      3                 01/04/2010  75       T   

      3                 01/05/2010  40       T   

      2                 01/05/2010  32       T   

      1                 01/05/2010  11       T   

      1                 01/06/2010  15       T   

      2                 01/06/2010  20       T   

      3                 01/06/2010  19       T

       

       

       

      O=Opening balance

      T=Transaction during the year

      OB=Opening balance

       

       

      From the above transaction table how to make a report in the following format:

       

      Month       OB       Qty       Total

      Apr            55       176       231

      May         231         83       314

      June        314          54      368

       

      plz help me out.

       

      regards

      chandan