7 Replies Latest reply: Nov 18, 2011 9:05 AM by Francisco Marotta RSS

    YTD cumulatives

    Hans kleijnen

      I have a table similar to:

      Bookperiod, Bookdate, GLaccount, Debit, Credit

      I succeed in creating a pivot table that returns the mutation (=Debit - Credit) per Bookperiod.

      accountperiod 1
      period 2period 3
      Header 5Header 6Header 7Header 8
      building111etc


      inventory213











       

       

      Now I would like to have per Bookperiod the YTD cumulative

       

      accountperiod 1period 2period 3Header 5Header 6
      building123etc
      inventory236







      how to do that?

       

       

      thanks

      Hans

       

      I have posted a related topic as an idea for future new releases. In case you like this, follow the link and vote.

      http://community.qlik.com/ideas/1885