Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I would like to make a dynamic selection in a filter that applies to the whole report.
The dynamic filter will be on my Year and Month field where an expression will calculate to select the current Year and last month from the current month.
I already have the expression for the two.
How do I enter this for a dynamic filter for the two fields?
Looks like 1st result in google query will give you an answer
How to Create Static and Dynamic Filters Based on Fields
Just to add to it
Having 2 fields and applying selections on both does not make sense as:
I would simplify this task by creating one date field for each month:
Then your filter on A_field would require only one expression and it would be:
hope this helps
cheers
Lech