pivot table

[upaliwije]

Hi Dear Friends

I have created the following Pivot Table from Data model

DEPT Dept 1 Dept 2 MONTH PRD Nos Amount Per Unit Cost Nos Amount Per Unit Cost May A 2,000 100,000 50 1,500 250,000 167 May B 1,000 300,000 300 2,500 175,000 70 May Total 3,000 400,000 133 4,000 425,000 106 Jun A 3,000 400,000 133 1,400 350,000 250 Jun B 4,000 250,000 63 1,700 200,000 118 Jun Total 7,000 650,000 93 3,100 550,000 177 Difference A 1,000 300,000 -100 100,000 B 3,000 -50,000 -800 25,000 Total 4,000 250,000 -900 125,000
					125,000

I want to add the calculation marked in red to my pivot table. Kindly let me know where there is any way to do this

[sunny_talwar]

Can you share a sample qvw document?

[qlikviewwizard]

Hi upaliwije,

Your provided data is very confusing. Can you attach the sample qvw with sample data. So that it will help us better understanding the issue and to provide the efficient solution by our folks.

[timanshu]

Hi UPALI,

This can be possible in modeling. Kindly share the data if you would like to do it that way.