Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, hope somebody can help me.
I'm trying to set a straight table with all the customers that don't have an invoices in the last X days. This variable X should be set with a slider (0-15 days step 1). The dimension should be the CustomerCode and if possible an expression showing the last invoice.
Does anybody have an idea how to do that?
Thanks in advance.
Suggest to use a formula like TODAY() - MAX(OrderDate) > SliderVariable
HTH Peter