Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=KPIMonth<Month(Today())
This creates an invalid result
Can anyone help?
kind regards
MJ.
Hi Martyn,
see: Re: "Less than" as filter issue
And: Re: Dynamic filter in Nprinting by month
HTH - Daniel.