Pivot calculation

[omnomnom]

Hi i have Excel table like this

		Suppl	SubCategory
Category1	2012	10 627	144 423
	2013	11 284	130 380
		6%	-10%
Category2	2012	10 627	565 008
	2013	11 284	549 901
		6%	-3%

How can i make it in qlikview?

[omnomnom]

Dropbox - xls.xls

xls for better understanding

[giakoum]

you can load the data without the % in QlikView and create the % difference as a column instead of a row.

[omnomnom]

Hi, im already have pivot table

but im dont know how to add 2013/2014 diffirence to red line place

[omnomnom]

this is result what i want to get/

[giakoum]

the only way to achieve that is to create the rows in your data model while reloading. Otherwise I don't think it is possible.

[#7]

Check out the Dimensionality() function in the help page of QlikViw. It will help you.

[Anonymous · Accepted solution]

Siarhei

Have a look at the attached.

Best Regards,    Bill

[omnomnom]

wow! big thanks!