Forum Discussion
Solved
Filter date -> Keep values between selected dates
Hi all, So... this needs to be simple but I just cannot understand it... I have several projects starting in 1.1.2023 and going until the end of 2030. I have a matrix table showing forecast...
JMHenriques ,
That is what is expected. You are filtering on Contract Expiry Date field and hence it will filter out all data which is not having Contract Expiry Date betwen 2023 and 2027.
If you want forecasted values between 2023 and 2027, then you need to filter on Forecast Year.
Check this:
JMHenriques ,
A simple filter should work. It would be a on or after 1.1.2024 AND on or before 31.12.2017. Forecasted costs of all projects between these 2 dates would appear in the matrix.