Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
reema_dangwal
New Contributor

Qliksense Pivot Table

Hi,

I have this monthly data that I need to display in a pivot table.

I am able to display Months as columns, however I need to display Total as a column  for all months except last month.

Say if I have data from Jan-Jul 2019, I need a total column  to average only Jan-Jun 2019, and then I need to show other columns for variance of total from July.

Please suggest how it can be achieved.

Attached is the data file.

Thanks