Question:
I have a simple Cube with 2 key figures (Quantity & Price), Two char Order, Version. In my layout i need Order and in data colum Quantity and Revenue(Qty * Price). Note i dont have a revenue column in my cube. and revenue is only for disply purpose. I will be planning on QTY and copy it to Plan version.
How to achive this.
Good day
John
Answer:
Are you using Excel layouts? If the planning is done on Quantity, you can put the price in the layout as well and then use normal Excel formulas to display the Revenue.
If you are using ALV layouts, I don't think there is a way to do that
Answer:
Guille,
on web, not Excell in Web. So obviously no VB code and nothing of that sort.
Regs
Jon
Answer:
I am afraid I cannot help you then. I have never worked with the Web front end
Sorry!
Answer:
Ho John,
It looks like you have to complicate your simple cuble and include a new key figure to store the revenue.
I'm really sorry,
Nelson