12 Replies Latest reply: Feb 19, 2014 2:17 AM by Nitin Surnar RSS

    Running Total

    Temieka Clay

      I have a pivot table in which I have debits and credits.  At the beginning of the year, there is a beginning balance of $600,000.  I want to be able to see in the pivot by date how this total changes based on the debits and credits.  In my expression for Running Total, I have the following:  If (FACTTYPE = 'CHARGEOFF',600000- Sum(CHARGEOFFAMOUNT)).  I also need to add when FACTTYPE = RECOVERY  as well.


      All suggestions welcomed.