Calculated Demension

[#1]

I'm trying to create a field "Take Rate" that is the sum of the number of parts sold/sum of the number of vehicle sold. As of right now, the take rate field is the sum of the each part sold. Is there anyway to reference another table to use as the denominator or is there anyway to reference the max value in the take rate field I currently have?

[vishsaggi]

This is what i can see in your qvw file for take rate. So, what is that you are trying here? And what is your expected output?

Sum({<[Sales Document Type]={'ZVHL'},[Document type]={'RV'}>}[Quantity])

[#3]

Vishwarath,

Thank you for the help. I was able to solve this problem by writing the Sum statement into the load script.

[vishsaggi]

Sounds good.