Top N results in Pivot Table less than 100%

[BobSullivan]

I have a pivot table that displays the top 15 values based on a percentage basis (Available/Accounted for). However, some of the smaller quantities only have a single unit available and thus a single unit accounted for. So I have rows that show say 300 units available and 270 accounted for, (90%). But I have other rows that have 1 available and 1 accounted for which comes out to 100%. These small totals skew the results.

My question is, how can I filter the pivot table to show the top 15 percentages, but not include the ones that have, say, less than 5 total units available?

[Rudi]

My 2 cents answer..
You could go back to the source data, add a new column and use a formula like: =COUNTIF($A$2:$A$21,A2) - replace A column in formula with Units column reference.
Then filter the pivot table so it excludes the units less than 5.

[PJ_in_FL]

Take the percentages as a total of the entire population of your list, then the top 15 of that list will be the items that are impacting your metric the most.

I.E. if your list contains 10 part numbers, some with 300 and some with only 1, and the total of all units is 400, then the part number with 270 out of 300 will show as (270/400)% = 67.5%, and the part number with 1 unit will be (1/400)% = 0.25%.