Forum Discussion
Filter date -> Keep values between selected dates
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 ,
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:
The thing is that I needed to keep the total with all the years but only show some of them.
But in the meantime, I reformulated the idea and totals will be presented in another way so indeed I will do that 🙂 thanks for the feedback.