Pat you do not state what your PO and PO Lines are so the amount of help I
can provide you is limited.

I have put a file up for you at:-

http://www.pierrefondes.com/

It is item number 30 towards the top of my home page (at the top at the
moment).

In EXCEL 2007:-

I will give explanation by way of reference to a file called pivot_top_ten.

In cell F16 there is a drop down button. Click this. Select Value Filters
then Top 10.

Pop up should appear with four fields:-

Show
Top 10 Items Sum of Value

Hit OK.

Top ten items (by Vendor) should now appear in the Pivot Table.

In the example that I have done Unilever does not appear in the Top Ten
which is correct.

If my comments have helped please hit Yes.

Thanks.


"pat67" wrote:

Hello, I have data that includes alot of fileds but my pivot table has
PO, PO line, Vendor, and value. I need to sort the top 10 values by PO
and line item. I cannot seem to figure it out. Can someone help?

Thanks
.