Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Alam
Contributor II
Contributor II

% change from previous month

I am making a pivot table as below: -

I'd like to have the % difference from Nov to Dec infront of December, Dec to Jan infront of January.

The expression I have used to calculate % total is: -

Sum(Total)/sum(total <Month> Total)

Alam_0-1675947115075.png

 

Labels (2)
1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

something like this.

Sum(Sales)/sum(total <Month> Sales)-Above(Sum(Sales)/sum(total <Month> Sales))

ogster1974_0-1675947692070.png

 

View solution in original post

1 Reply
ogster1974
Partner - Master II
Partner - Master II

something like this.

Sum(Sales)/sum(total <Month> Sales)-Above(Sum(Sales)/sum(total <Month> Sales))

ogster1974_0-1675947692070.png