Pivot Link Total

[KC3]

Hi Qlikians,

Please help me to get the data from my Link files

1 st file (Own_Web) is my Sales data from Different Marketplaces. so here i have Code.

2nd file (sheet1) is Against code i will get my Sku.

3rd file  (cogs)is Against Sku i will get my Cost Price

4th file (MRP) is against Sku i will get Category, Sub Category.

I am trying to calculate my COGS against Cat, Sub Cat, Sku, but not getting the total.

Please help me to get the TOTAL of Cost Price.

[justISO]

Hi, maybe

sum(Quantity*[COST PRICE])

[KC3]

the amount will be change.

Already applied PFB ss for the same