Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agostinierika
Partner - Contributor
Partner - Contributor

Can I calculate the difference between two columns of a pivot table?

Good morning, I need to know if  it's possible to put inside a PIVOT an additional column containing the difference between the amounts of two other columns.

Basically I need to insert a third column that calculates the difference between the first two scenarios, but in my excel are contained in the same column (as it's possible to see in the following image) and thus I can't use the formula Sum (X) - Sum (Y).


Thanks in advance for the attention


qlik.png

0 Replies