Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Pivot Table Cumulative data

Hi ,

I have an excel with sample format and numbers for Actual and Budget. I need cumulative addition of Actual, Budget, Actual-Budget and the variance calculations till the current month(for YTD) , in the sample example its  'Apr'.  And rest of the columns in pivot (Average Actual and Budget- actual )only for YTD month that is Apr only. so first four column for all the months till April(with cumulative values for the fields) and next two columns only for the month of April. 

Any help will be appreciated.





1 Reply

Re: Pivot Table Cumulative data

It might be easier to help if you are able to share the app where you are trying to do this.