Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jsingh71
Partner - Specialist
Partner - Specialist

Pivot Table??

pivot.bmp

I make a pivot table showing above, now I want to Compare Q2 with Q1, Q3 with Q2 and Q4 with Q3. I want to subtraction from the same and show into a new column.

Please help.

2 Replies
sujeetsingh
Master III
Master III

Just paste a sample ..

And you can easily do it with set analysis

jsingh71
Partner - Specialist
Partner - Specialist
Author

in 'utilaization' column if we subtract 81.08 - 82.96. we get sum value. Like this I want to subtract values from there previous values