Pivot Table for the top 10 lowest companies

[Redgirl9487]

I was wondering if someone could help me please?

I have managed to create 2 pivot tables for the top 10 and bottom 10 companies. However, for the top 10 bottom companies more than 10 companies show.

Please can anyone advise how to rectify the issue so only 10 bottom companies are showing. Currently it is showing 22 companies, and I have re-done the pivot tables numerous times and it is still not showing the top 10 bottom.

Many thanks in advance

 

[Skybluekid]

This worked

Book1
	G	H
2	Row Labels	Sum of 1
3	Company 2	2
4	Company 3	3
5	Company 4	4
6	Company 5	5
7	Company 6	6
Sheet5