Show as far as today

[bobbydave]

Hi all,

I just know I am asking the most idiotic question but cant fathom it.

I have a dimension (Cancellation_Date) that will show data as far as the Year 2099.

However, I only want my graph to show up to today.

Any ideas?

[Gysbert_Wassenaar · Accepted solution]

Change your expressions so they filter on Cancellation_Date. For example sum(Amount) would become sum({<Cancelation_Date={'<=$(=ToDay())'}>}Amount)