Calculation of percentual increase of calculated dimension

[#1]

Hi, QV community

I would be grateful if someone could help me with the following issue.

I set a simple dataset with dummy data.

I need to calculate the percentual difference between hist.sales and forecast

In the pivot chart, I added a calculated dimension =(fcst-hist)/hist

I works fine for lines, but I need to make the same operation with totals (as Excel pivot charts automatically do!!!)

In short, I need QlikView to calculate and show the value in yellow

(sum(fcst)-sum(sales))/sum(sales)

Thank you in advance!

base data

article	Hist.sales	Forecast	% increase
item 1	15	18	20,00%
item 2	17	22	29,41%
item 3	19	27	42,11%

intended report

Etiquetas de fila	Hist.sales	Forecast	% increase
item 1	15	18	20,00%
item 2	17	22	29,41%
item 3	19	27	42,11%
Total general	51	67	31,37%

[nagaiank]

If you set the Total mode to expression total, you get the desired result.

[#3]

Now it works! Thank you for your help!