I have a mega table report that is displaying customer invoice data. One of my filters is for the Aging Range. I have been asked to modify the filter to include all invoices for a customer if any of their invoices are in the filtered range. Meaning that in the below dataset if they selected to filter 151-180 all invoices for Customer A would still be in the report. This allows the user to see a full picture for that customer.
Maybe my brain is just tired, but I'm just drawing a blank on how to make this happen.
Customer | Invoice | Aging Range |
---|
Customer A | Invoice 1 | 151-180 |
Customer A | Invoice 2 | 91-120 |
Customer A | Invoice 3 | 31-60 |
Customer A | Invoice 4 | 1-30 |
Customer A | Invoice 5 | 1-30 |
Customer A | Invoice 6 | 1-30 |
Customer A | Invoice 7 | 1-30 |
Customer B | Invoice 8 | 91-120 |
Customer B | Invoice 9 | 31-60 |
Customer B | Invoice 10 | 31-61 |
Customer B | Invoice 11 | 31-60 |
Customer B | Invoice 12 | 1-30 |
Customer B | Invoice 13 | 1-30 |