Aging Best Practice

[zahidrahim_ocp]

Dear Experts,

I have a Date Column with the name Due_Date and few Amounts columns. I want to calculate aging based on a selected date. 

If i keep due_date in filter and calculate buckets based on selected due date then dimensions fall other than selected date stopped getting found.  

I wonder what should be the best practice to calculate buckets and all dimensions ramained searchable.

Regards,

Zahid Rahim