Weighted average based on a reference measure

[former_member687521]

Hi,

I need to break-up the Sales data (Planned ) based on quantity (Actual) in the proportion using a data action. User enters a Sales value at Prod.Hier4 level and the value has to split based the weighted average of Actual Quantity to product level . Please let me know,how we can achieve this. Please check the screen shot for better understanding.

Thanks

SV

[N1kh1l]

Hello,

Please explore using the SAC Allocation feature. Alternatively you can also try Advance formulas.

Allocation help:

https://blogs.sap.com/2020/10/28/sap-analytics-cloud-allocation-series-introduction/

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/2eb9dbe056684f15bd850...

Advance Formula Help.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/766b9da1890d431ca2992...

Regards

Nikhil

[William_Yu]

Some hints on script:

1. user create VIRTUALMEMBER for product: #ALLPROD
2. Collect total quantity for all produc into #ALLPROD
3. sales * quantity per prod / #ALLPROD