Allocation of Cost by % of Sales

[seva369]

Hi,  I have data set including locations, revenue and cost types and amounts. I d like to calculate allocated cost to each rev type based on the share of the sales performance at each location. Like in table 2 . Can you help me with this please, thanks

[seva369]

Thank You Ashish, that worked really well

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur]

Hi,

Your question is not clear.  How did yu arrive at 13.64?  Based on the first table that you have shared, show the expected result along with the calculation logic.  Also, share data in a format that can be pasted in an MS Excel file.

[seva369]

Hi, 

Thank you for the response.

Unfortunately it doesnt allow me to paste or create tables or attach excel & pbi files. 

You can find screen shots below - 45.5% is the share of Digital sales at that location

Many thanks in advance
Serhan
.

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached my solution file.

Hope this helps.