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

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

enter image description here

In my source data tab I have the following date:

enter image description here

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.

1 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.