5 Replies Latest reply: Feb 9, 2012 8:00 PM by Sokkorn Cheav RSS

    How to get Accumulate for Show Partial Sum in Pivot Table

    Sokkorn Cheav

      Hi All,

       

      I face one problem with Pivot Table for sum accumulate data. Let see the pictureCummu2.jpg

      ***For Pivot Table have

          4 dimensions : Transaction, Type, Codes and Weeks

          1 expression : SUM(Cash)

       

      ***The dimension <Weeks> is need to drag from vertical to horizontal

       

      **For TOTAL in <Type> dimension

      + Incomming Cash

          - Total in W07-2012 = $36,440.91

          - Total in W08-2012 = $36,440.91 + $15,386.79 = $51,827.70

          - Total in W09-2012 = $36,440.91 + $15,386.79 + $16,322.32 = $68,150.02

          - And so on...

       

      + Outgoing Cash

          - Total in W07-2012 = ($1,416.21)

          - Total in W08-2012 = ($1,416.21) + 0 = ($1,416.21)

          - Total in W09-2012 = ($1,416.21) + 0 + 0 = ($1,416.21)

          - And so on...

       

      **For TOTAL in <Transaction> dimension

          - Total in W07-2012 = $36,440.91 + ($1,416.21) = $35,024.70

          - Total in W08-2012 = $51,827.70 + ($1,416.21) = $50,411.49

          - Total in W09-2012 = $68,150.02 + ($1,416.21) = $66,733.81

          - And so on...

       

       

      Please help to guide me how to get this done like picture2.


       

      Many thanks for your help.


       

      Enclosure

       

      Pivot Cumm.qvw


       

      Regards,

       

      Sokkorn Cheav

       

       

      Please help to guide me how to get this done like picture2.

      Many thanks for your help.

      Enclosure

      Pivot Cumm.qvw

      Regards,

      Sokkorn Cheav