I have a pivot table in Qlikview 11.
1) Original - is my original pivot table
2) Final - is the pivoted version of Original
3) Result - this is what the result needs to be
How to calculate the difference columns - DIFF1, DIFF2, DIFF3 in the same format as attached? Please help.