Share Of Business Calculation

[Deep Dave]

Hi All!

I have loaded some data in the Excel 2013 Data Model, where 1 Column is of Sales Amount.

I have 10 different customers with lot of Invoices that result to that sale.

How can I calculate the Share Of Business of each customer from the total sale?

For E.G. - if my total sale of 10 customers is 1000, and Customer A has resulted to a sale of 100, that means the Share of Business for Customer A is 10%.

How do I calculate it for all the customers?

Thank You,

Deep

 

[Deep Dave]

Any Help?

 

[subrosumon]

Hi,
Just
[TABLE="width: 265"]
<TBODY>[TR]
[TD]Sale</SPAN>[/TD]
[TD]1000</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A</SPAN>[/TD]
[TD]100</SPAN>[/TD]
[TD]10% = </SPAN>[/TD]
[TD]$G$28/G27</SPAN>[/TD]
[/TR]
[TR]
[TD]B</SPAN>[/TD]
[TD]200</SPAN>[/TD]
[TD]100% =</SPAN>[/TD]
[TD]$G$28/G28</SPAN>[/TD]
[/TR]
[TR]
[TD]C</SPAN>[/TD]
[TD]510</SPAN>[/TD]
[TD]50% =</SPAN>[/TD]
[TD]$G$28/G29</SPAN>[/TD]
[/TR]
[TR]
[TD]D</SPAN>[/TD]
[TD]190</SPAN>[/TD]
[TD]20% =</SPAN>[/TD]
[TD]$G$28/G30</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=3><COL></COLGROUP>[/TABLE]