In product margin report, i have the following coloumns,
1. Total Revenue consist of (Existing Business(Actual values) & Forcating business(planned values).
My understanding Total revenue - Cost of sales = Total Margin (Gross margin)
2. Gross margin (%) - Gross margin/Revenue *100 - (Gives in %)
These report has been created in excel.
If i want to do in BW & BPS
I presume i need to create this report in Query designer(BW) and then crate a layout in SEM-BPS where i enter planned values. After entering the planned values , where i can see the actual report , i understand it is recorded in infocube.
Pl could anyone advice me iam i right what iam doing, Kindly suggest me....