Sum of Calculated Measure not Working

[knotty150]

Morning All
I’m having a very annoying issue with a calculated measure not summing up correctly in a PivotTable. The calculated measure is attempting a weighted average; it does everything correctly at the row below level, but sums a field it makes reference to in the formula, as opposed to summing the formula itself. Can anyone provide a solution/explanation without me going into the detail of the dataset/formula? Obviously I’ve got it all to hand if need be.
Thanks in advance!
Rich

 

[XLBob]

Rich, find the files below. I have added a dynamic measure based on the date selection. Try with more data and let me know if it works for you.

https://onedrive.live.com/?cid=7DF5E31C189063EC&id=7DF5E31C189063EC!124&mkt=zh-CN

 

[knotty150]

Hi XLBob

That works spot on. Thank you very much indeed for your help!

Rich