Sumproduct of actual Quantity and Target Cost

[tabisen1]

Dear All,

Hope all are safe and healthy in covid-19 condition.

I need urgent help on the below. I have created the  Pivot table in QlikView I stuck in the Below working where I have to do the sum product of Actual Quantity and Trade Cost as shown in below table marked with Red color and Sum of all marked with maroon color.  

File attached below

Table Required  

Pivot table created in QlikView want to add Marked with Maroon color and want to delete the nos. marked with Blue Color. 

Need support to finish my work.

Regards,

Tarun Bisen

[Frank_Hartmann]

try to enclose your expression/s with sum(aggr( at the beginning and ,PLANTNAME,REGION,DEPOT,TALUKA)) at the end. This should show the correct Totals.