ggenovese Coach

In order to apply a range filter, you need a number to filter on rather than text. If you were to include the actual age of the invoice in your dataset then you can filter on the range of days. In your example that would be 0 to 180 days. However, a range filter would also include the invoices for Customer B. If you still…

You can do this by combining a Variable with a Fixed Function. First create a variable named "Age Range" and populate it with your Aging Range bins, then create a beast mode: CASE WHEN Customer = MAX(MAX(CASE WHEN Aging Range = Age Range THEN Customer END) FIXED (BY Customer)) THEN 'Include' ELSE 'Exclude' END place the…