Monthly closing balance RRS feed

  • Question

  • how can I used formula closing balance in power pivot in following

    Power pivot table

    ----------------------------------------------January Closing balance-------------------------------------------February closing balance

    Item code  PKt Received Qty--------Issued Qty------------Balance Qty.-------Received Qty-----------Issued Qty-------Balacne Qty

     ITM-1        50kg   30                       10                            20                       100                         50                        70

    Pleaser put formula to calculate the results

    Sunday, May 31, 2015 9:22 AM