Looking for some help with Pivot Tables and Top 10 Filter

[grabrail]

So I am creating a pivot table/chart from a large set of data I have.

For this chart I am trying to see the top 10 "count" of a certain column. So I choose the Value filter Top 10. Great, works as you would expect.

However, on a lot of the rows, there is "N/A" as an entry, and these make up the number 1 spot on my chart as there are far more N/A than other entries. Is there a way I can display the top 10 but no count the N/A, so the 10 ten actually starts from the second most popular entry and goes to the 11th?

I have tried creating the top 10 value filter, and then filtering out N/A, but this just seems to replace the top 10 filter and shows everything apart from N/A

Hope this makes sense

 

[awoohaw]

Can you post a mini workbook with your data source and pivot table with the xl2bb add in, please?
It would help the forum in testing out solutions to your scenario.

 

[grabrail]

This is a snippet of the table I am creating the pivot table/chart from

Database.xlsm
	A	B	C	D	E	F
1	Gatecheck ID	DPU Report No.	Check No.	Defect Found	Serviceable	OCRS Score
2	1	1	N/A	Driver seat is completely worn and needs rectification	DP	25
3	1	1	N/A	Spray Suppression is clogged in excess of 25%	DP	25
4	2	2	N/A	Spray Suppression clogged in excess of 25%	DP	25
5	2	1	N/A	No Additional Defects Found	N/A	0
6	2	3	N/A	No Additional Defects Found	N/A	0
7	2	4	N/A	OS mirror mounting bracket is structurally deteriorated	DP	25
8	3	4	N/A	NS mirror mounting bracket is structurally deteriorated	DP	25
9	3	2	N/A	No Additional Defects Found	N/A	0
10	3	1	N/A	Spray suppression is clogged in excess of 25%	DP	25
11	3	3	N/A	No Additional Defects Found	N/A	0
12	3	5	N/A	No Additional Defects Found	N/A	0
13	4	1	N/A	No Additional Defects Found	N/A	0
14	4	2	N/A	No Additional Defects Found	N/A	0
15	5	1	N/A	No Additional Defects Found	N/A	0
16	5	2	N/A	No Additional Defects Found	N/A	0
17	5	3	N/A	No Additional Defects Found	N/A	0
18	6	2	N/A	No Additional Defects Found	N/A	0
19	6	3	N/A	No Additional Defects Found	N/A	0
20	6	1	N/A	Spray suppression partially blocked	S	0
21	6	4	N/A	No Additional Defects Found	N/A	0
22	6	5	N/A	No Additional Defects Found	N/A	0
23	7	1	N/A	Spray Suppression Partially blocked	S	0
24	7	2	N/A	No Additional Defects Found	N/A	0
25	7	3	N/A	Spray Suppression partially blocked -	S	0
26	7	4	N/A	No Additional Defects Found	N/A	0
27	7	5	N/A	No Additional Defects Found	N/A	0
28	7	6	N/A	No Additional Defects Found	N/A	0
29	7	7	N/A	No Additional Defects Found	N/A	0
30	7	8	N/A	No Additional Defects Found	N/A	0
31	7	9	N/A	No Additional Defects Found	N/A	0
GateCheckDefects

and this is the pivot table created

Database.xlsm
	A	B
3	Row Labels	Count of Gatecheck ID
4	No fleet insurance certificate in vehicle	2
5	Spray Suppression is clogged in excess of 25%	2
6	ADR paperwork out of date	2
7	N/S air leak	2
8	VTG 6 Not present new vehicle	2
9	Spray Suppression partially blocked -	2
10	More than 25% of Spray suppression is clogged with dirt	3
11	Spray Suppression over 25% Blocked	4
12	Spray suppression partially blocked	7
13	No Additional Defects Found	337
14	Grand Total	363
Sheet4

The entry I want to filter out of the top 10 on this list is "No Additional Defect Found"

 

[grabrail]

I found what I needed, you need to go into the Pivot Table Options and allow "multiple filters" setting