Skip to Content
0
Jun 24, 2022 at 07:12 AM

Weighted average based on a reference measure

98 Views

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

screenshot-2022-06-24-123527.png

Attachments