Price * Sum*(Volume)
It will give the correct value if i am right Price is already aggregated value and Volume is the direct field that's why you are getting the aggregate and non aggregate error,
if price is not aggregated, volume is aggregated then change the calc like below
Hope this helps kindly mark this answer as correct/helpful so that it will help others
Are you not able to do this:
I am not able to do sum(Price*Volume) nor Price * Sum*(Volume) nor Sum(Price)*Volume, all these options result in the error that it cannot mix aggregate and non-aggregate...
The prices come from a different excel source that is blended with the volume data source, if that has anything to do with it?