Since we don't have a way to deal with ties in the PivotTable Top 10, I'd suggest that the best route is probably to add a column of data to your Pivot source, and create a formula to deal with the ranking there. Maybe set the formula to only count the first 10 items, then filter the entire table by that column?