Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
60
Views
Topic starter
Hi,
I have a data table that contains sales by country and customer account number. I want to get a report that shows me the top or bottom 10 customers for each country based on the sales for that country.
This is a piece of cake with pivot tables but is it possible using Power Query?
I have attached a file that shows the data table and my pivot solution for the top 10 by country.
Thanks
Bax
Posted : 10/12/2021 12:30 pm
Hi Bax,
You can use Group by to get the total sales by region and customer. And then you can number the grouped data, and lastly filter it to only show the first 10 records.
Mynda
Posted : 15/12/2021 9:40 pm
