Dear Experts,
I have a requirement to calculate revenue using Price and Quantity for each material,month,sales org combination using FOX formula.
Problem is that price and quantity will be in different rows in the cube.

A new record with version C has to be created with a row for each combination also populated with Price, quantity and revenue.
Could you please advise how this can be achieved.