Maybe I'm not following exactly, but if you're looking for the top 5 items, why not just filter the PivotTable to the top 5? I'm not sure what version of Excel you're using, but in Excel 2010 (and 2007 I believe), you can do this by clicking one of the dropdown filters on the table, selecting Value Filters --> Top 10, and then you can set how many you want. I'd probably just set up a top 5 table for each view I needed.
For a more detailed walkthrough, Debra Dalgleish has an excellent article on her site of working with Top 10 filters: http://www.contextures.com/excel-piv...ers-top10.html
Hope this helps,