How to add a calculated column in a pivot table

[#1]

Hi,

the pivot table in the image has as a column filed 'Divisa' which has two values '<Entity Curr Total>' and 'Mloc', but the expressions in the pivot table is just one 'sum(Importe)'.

How could I to add a new column with the 'sum(Importe)' difference between the values of 'Divisa' called '<Entity Curr Total>' and 'Mloc'?

Thanks

[#2]

Sorry I'm affraid there is not a good solution for this.

Regards.

[veidlburkhard]

Hi Luis,

when I look at your picture, I see the two columns have the same values in each row. So the difference will always be zero (0) !?! Or am I misunderstanding something?

Regards

Burkhard

[#4]

Hi Burkhard, you are right excepto for some rows which have '0' but anyway I would like the difference betwen them. Regards.

[Anonymous]

Hi all,

I am facing the same problem, i set up a Pivottable with coumns (Year) for Year 16 and Year 17 and Revenue as Dimension; but no body seems able to suggest any useful solution to get the variance (both dollar amount and %).  Maybe Qlik is not as good as Excel.  With Excel, i did it within 30 seconds.