Forum Discussion
Cumulative sales by Country
Hello!
I have a simple spreadsheet with - among the others - customer, sales and countries columns.
What I want to do, is to calculate per each client how many countries make up to 80% of sales e.g. for nike we may have 2 countries that makes up 80% of their sales, whereas for Adida 5 countries as we have more footprint.
THanks,
a.
4 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - Ashish_Mathur
Hi,
Do you want to know "how many countries" or "which countries"? Also, share data in a format that can be pasted in an MS Excel file.
Ashish_Mathur I want to know how many countries 🙂
See below a sample dataset:
Country Client Sales USA Nike 2121230 UK Nike 41213 Germany Nike 456531 France
Adidas 46546 France Nike 564456 Germany Adidas 545646 Italy Adidas 64565 - lbendlin
Your sample data doesn't work for the question you asked. Please provide meaningful sample data.
