Using a macro to filter text data with a wildcard in a pivot table erroring out

I'm trying to use a wildcard to sort the data.

Capture - Copy.JPG

Trying to sort this data by the first column to get a report showing all the ABC items along with any N/A items and any blank items.

When trying a macro that has this in it:

Please Login or Register  to view this content.

I get an error:

Run-time error '1004':
AutoFilter method of Range class failed

When trying to use:

Please Login or Register  to view this content.

I get an error:

Run-time error '1004':
Unable to get the PivotItems property of the PivitField class

I'll admit I'm not familiar with slicers so I will check that out.

Here's more detail on the problem and what I am attempting to accomplish. What I have is a report that I get which needs to be sorted, filtered, formatted, and then emailed out to different groups showing the employees they are responsible for. The first 3 letters define an overall department group. So "ABC-*" is one group, "DEF-*" is another group, etc. The report needs to be broken out to all "ABC-*", "N/A", and "Blanks" and saved off for emailing. Then it needs to be broken out for all "DEF-*", "N/A", and "Blanks", saved off, and so on continuing down the list. There's a few more 3 letter prefix designations which aren't showing on the screenshot that will need filtering along with the "N/A' and "blanks". All said it ends up being 5 or 6 different reports that get broken out and mailed off.

Since this needs to be done on a regular basis I am looking to run a macro to handle the repetitive tasks.

The Dept is dynamic. Today there may be 3 "ABC-*" departments listed. Tomorrow there may be 2 more added, the day after that there may be 3 removed. It's fluid. If it was static I could just define each possible option and just have the macro make it visible or not using the full text. However, since the text after "ABC-*" could change daily, I thought I would need a wildcard to identify it and make anything with "ABC-* visible and make anything with a "DEF-*" not visible, save it off, then make everything with "ABC-*" not visible, make everything with "DEF-*" visible, save it, and so on for each Department group on the report.

Filtering with Wildcards seems to be giving me issues when using it on the pivot table above. I've got it working correctly on other reports I run with Pivot tables. I'm guessing having that Sum of Hours Entered in Row 1 is throwing things off because that is the only difference I've found in the 2 options. I'll check the Advanced Filtering and Slicer to see if that can give me what I need. Ideally I'm looking to automate this as much as possible. Honestly, This part of the macro is just to stop me from having to go in, uncheck all, and recheck off what I want to report on for all the different Department Groups. It's a few minutes each day, but it seems like something that's perfect for automation since it is a repetitive task.