Calculate Savings on the Item level - average cost

[#1]

Hi there,

Basically I have list of Items with Sales Qty, Sales Period, Cost Price and Cost Centre. I am comparing average Cost Price between two periods and then multiplying difference by current Sales Qty to see any Savings due to Cost Price change.

Please see attached file - "item level v2"

You can see that in the table "Saving by Item" all Savings numbers and Total number (sum) looks fine. But using the same calculations in the "Saving by Cost Centre" table the numbers are totally different - special Total number. 

For example Cost Centre 106 shows £2,005,968. But when you actually select 106 the top table shows £301 - which is correct.

My question is, how can I display numbers based on the Item level in the "Savings by Cost Centre"? How to calculate correct savings on the different levels?

Thank you for any response,

Dave

[#2]

Hi,

All expressions are wrong way. you can keep set analysis properly.

[#3]

Hi, I'm sorry, bu not sure what do you mean?

[Gysbert_Wassenaar]

See attached example.

[#5]

Hi there,

I can see that total numbers work fine. But for example in the "Saving by Cost Centre" table you have £-13,619 and when actually I select 106 it should be £301. I would like to see that number in the Cost Centre view. Is it possible?