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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtraction of dimensions in a pivot table.

I have a pivot table which has 2 dimensions and want to add a further dimension which makes me a subtraction of the 2 dimensions that are above. Can this be done in a pivot table?

Thanks!

2 Replies
robert_mika
Master III
Master III

Not sure about the word "above"

But you can add an expression

Dimension1 -Dimension2

Not applicable
Author

Resta.jpg

Thanks for your answer, I attached an image to make it more useful, I want to make the subtraction to the field records "Revenue" and "Operating Costs" and display the subtraction in the "Subtraction" field, this in a pivot table.