It is now July - month 7 and I want to select Jan to June, using a filter
=KPIMonth<7 works great, but I need this to be dynamic so I tried
This creates an invalid result
Can anyone help?
see: Re: "Less than" as filter issue
And: Re: Dynamic filter in Nprinting by month
HTH - Daniel.
Retrieving data ...