Multiple Label Criteria - Pivot Table

[philipq]

Greetings Friends,

Below shown is part of a pivot table.
The data range is actually huge to the range of 58,000 plus records.
These are call center data spooled from the server to excel.

Now, I need to filter only those in the labels that end with:-
FORD
JLR
FM
POC
FER
MAS

How do I go about doing so?
Can this be accomplished easily via some VBA method other than on a pivot.

Row Labels	1	2	3	4	8	10	13	14	15	Grand Total
ALA-ARA-FI		1								1
ALA-ARA-SAL-FORD	3	22								25
ALA-ARA-SAL-POC	2	21								23
ALA-ARA-SER	89	199								288
ALA-ENG-FI	1	2								3
ALA-ENG-SAL-FORD		2								2
ALA-ENG-SAL-JLR	1	6								7
ALA-ENG-SER	18	36		2						56
ALA-PARTS	22	11								33
ALQ-ARA-SER	6	24								30
ALQ-ENG-MAS	44	114								158
ALQ-PARTS	4	9								13
CEN-ARA-COM	202	325								527
CEN-ARA-FI	65	49								114
CEN-ARA-PARTS	91	96								187
CEN-ARA-SAL-FM	12	35								47
CEN-ARA-SAL-FORD	87	292								379
CEN-ARA-SAL-JLR	56	284								340
CEN-ARA-FER	266	614	1							881

<colgroup><col><col><col><col span="3"><col span="4"><col></colgroup><tbody>
</tbody>

 

[pbornemeier]

Add a helper column to your data with this formula in row2 of that column:

=IF(OR(RIGHT(A2,4)="FORD",RIGHT(A2,3)="JLR",RIGHT(A2,3)="POC",RIGHT(A2,3)="FER",RIGHT(A2,3)="MAS",RIGHT(A2,2)="FM"),"X","")

Copy it down, then copy/paste special values that column.

Expand the pivot table to include that column and filter on that column for an "X".