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:

• Year (formula: = config!B3)
• Month (formula: = config!B2)

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.

Answer 1

You should change your custom formulas to

• Year formula: ='time tracking'!A2:A=config!B3
• Month formula: ='time tracking'!B2:B=config!B2