Hi Folks. I am newbie to Power Pivot and Power Query. I moved to the Power side since I need to pull form two data sets. My issue is I have created a new Power Pivot and I am using the Top 10 Value Filter for scores, but my data has many recurring values so my top 10 may be 20 or so returned...
Hi Dears,
This is pushing me crazy, sounds so simple but it is not working out!
I want to filter the top N calculated values in a pivot table, but it keeps filtering the top data point values!
For example, below is my pivot table
added the "Amount" Field again to the Values section >>...
Hi. I am working on a audit form that uses the excel advanced filter by having the user input data into the criteria range and then results are copied and pasted from other hidden sheet into a table below their data entry. I had to add a helper column in my rawdata to rank the details but had to...
I have a report that we are trying to filter for the top/bottom reps for each manager. Even if we filter for the manager name first and then apply the top/bottom 10 filter built into excel it is only returning the top/bottom 10 based on the entire worksheet.
Is there an easier way to look at...
I would like to know how to determine the original criteria used when someone filters with a 'Top10' autofilter.
The set of filters called 'Top10' actually includes four different filter types Top10Items, Bottom10Items, Top10Percent, and Bottom10Percent. Note that the names for these filters is...
Dear all,
I am building an Excel Dashboard and therefore have to use quite many pivot tables. I am now creating a top 10 list of potential customers based on the potential sales amount and am using the top 10 filter that is available in the filter section. However, I have now two problems:
No...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.