custom formula in pivot table google sheets

Question

I'm trying to filter on a value in a call in a pivot table.

In my "config" tab I have the following data:

In my source data tab I have the following date:

And in my pivot table I have two filters with custom formula:

The problem is with the month filter. If I filter on that, no results are shown. The year parameter works.

You can find the sheet here.

score 1 · Accepted Answer · answered Aug 29 '22 at 16:37

1

You should change your custom formulas to

answered Aug 29 '22 at 16:37

marikamitsos

1 Answers1