Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Table with customers with no invoices

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.

1 Reply
prieper
Master II
Master II

Suggest to use a formula like TODAY() - MAX(OrderDate) > SliderVariable

HTH Peter