how to insert difference in the same chart

[#1]

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.

[Anonymous]

Did you try:

Column(1) - Column(2)

?

[#3]

I found the solution (http://community.qlik.com/message/24253#24253) through your sugestion. Thanx

[v_iyyappan]

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