Forum Discussion
Top by Columns
Nice day
I appreciate your support if you can help me with a top, where I need to bring the first 3 "consumption ranges" for the total value and organize it by the total in descending order.
It would look like this:
It should be clarified that within the row, I also have the top 10 of the main products.
Thank you all very much for your support.
2 Replies
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Good night
What a pity, it does not let me attach information, but I have already uploaded it to dropbox so you can view it
https://www.dropbox.com/sh/sjq15z5bxdoibya/AAAe2m6icW5z2G3HdasRKcXxa?dl=0
Upload 3 files:
- Excel where it contains the data in one sheet and a PivotTable in the other.
- The power bi I've been working on, which is very simple
- Word step by step of what I do in Excel to find the result
Thanks a lot.
