Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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