Using Filters with Pivot Slicers

Hello!

I have a data set full of ad campaign results. The campaign naming convention is not consistent, but some of the campaign names have the word "marketing" in them, and some of them contain the word "sales." I'd like to create a slicer to quickly differentiate between sales and marketing campaigns without having to select every single sales or marketing campaign (there are about 50 campaigns total). I know that I can use the report filters to do this, but I like slicers because they're faster. Is there any way to do this? Perhaps by combining a filter or an "if, then" statement with the slicer?

Thank you all very much!

Hi Rachel,

Welcome to the forum!

Let me tell you that you are thinking in the right direction.

You can get the output from any one of the following points in which you are comfortable:

1. You can use Pivot tables & then add slicer to get the desired output.
2. Use Formulas.

If you can post dummy data file what you want as Output then the chances are high to get your problem resolved.

Regards,
AM