This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello all,
I'm really confused the Top 10 Percent how works! I also googled it but didn't find an obvious explanation. For example, in below table, I click on the Top 10 option (of column Percent) and choose the Top 10 Percent from that dialog box. But it only shows the biggest percent!
First, how this option (only top 10 percent) exactly works please? Then, why it doesn't show the top 10 percent for that Percent column?
Thanks.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi,
There are only 15 values in the % column and 10% of 15 is 1.5 so Excel displays 1 value for the top 10%.
If you extend your column you will get 2 numbers displayed when there are 20 values in the column.
I think what you should be filtering is the top 10 Items.
What about 5 percent. I chose top 5 percent so in your point of view it should show 3 values, not? But it again showed only that one again!
Hi,
No that's incorrect, here's how it works.
Once again 15 values so 5% of 15 is 0.75 so you get 1 value displayed. If you set the filter to 15% then 15% of 15 is 2.25 so you get two values displayed and for to 20% you would get 3.
What about 5 percent. I chose top 5 percent so in your point of view it should show 3 values, not? But it again showed only that one!
How it has chosen the higher 10 percentages? The result shows only one percentage (4350%) not the top 10!
Hi, it will filter by the higher 10 percentages hiding everything else, what would you like to do?