I need to pull the top three items to display in a report. Sorting is not an option due to other limitations. I need to pull the top three from this list, but am running into errors because there are multiple of the same value. This means pivot tables return more than three values, and the LARGE function returns the same value twice.

Here is an example:

Apples 50%
Bananas 25%
Oranges 25%
Kiwis 0%
Guava 0%

When I use pivot charts for top 3, it pulls all five of these. When I use the large function, it pulls Bananas twice.

Please help!