Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
pretty sure (or hoping) that there is a simple answer, but I was not able to track it in other posts. I have a set of sales data, one of the column is YEAR, I have a pivot chart showing sales of this and previous year and I'd like to insert a third column with the difference, I tried multiple ways (wih label for toals) but none is giving the result wanted, or I'm doing something wrong. Now I'm using a second chart, but it's not handy.
Thank you in advance
M.
Did you try:
Column(1) - Column(2)
?
I found the solution (http://community.qlik.com/message/24253#24253) through your sugestion. Thanx
Hi
I think difference of first two expression in third column right? if right means
use the expression in third column like = column(1) - column(2).
I attached a sample file using pivot table
Regards,
Iyyappan