Excel - How many shops account for 5% of sales
Suppose I have a table where one column is "Shop Address" and another column is "Sales". I want to have a table that shows:
5% of total sales are generated by the top X1 shops
10% of total sales are generated by the top X2 shops
15% of total sales are generated by the top X3 shops
20% of total sales are generated by the top X4 shops ... etc
How would I do this? It sounds simple, but I can't think of how to do it.
Suppose I have a table where one column is "Shop Address" and another column is "Sales". I want to have a table that shows:
5% of total sales are generated by the top X1 shops
10% of total sales are generated by the top X2 shops
15% of total sales are generated by the top X3 shops
20% of total sales are generated by the top X4 shops ... etc
How would I do this? It sounds simple, but I can't think of how to do it.
No comments:
Post a Comment