Creating a Calculated Field and Having the Column Total be A Sum Instead of Calculation

[njd763]

I am having an issue where my calculated column is correct, but it is a measure with other measures as the input. Since the other measures are also doing their calculations, the total of the column is a calculation versus a total of the calculated values. For example, my calculated column is taking ((old price-new price)*new units). It shows the correct value for the drilled down level (product lines) but it doesn't show the correct value for the rolled up level (product groups). How can I make it so the grand total at the bottom is just 

[vanessafvg]

you will need to provide more information as it is probably not possible to fix your issue with out your measure, and some data.

however it does sound like potentially you may need to iterate with a sumx or similar.  on the drill down level, the row context is probably be correct but its the filter context that might be not working, need your measure code and data to understand why,