Multiple Label Criteria - Pivot Table
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.
Kindly refer to the attachment for the pivottable.
Regards,
Philip
| Attachment | Size |
|---|---|
| SAmple.xlsx | 10.76 KB |
several ways: 1. Add a
several ways:
1. Add a boolean (true/false) calculated column with a formula to say whether the row is one of your target
2. Create the pivot table, then group the fields together
-> select the fields on the pivot table, right click and group
... my pref is (1)