two date slicers

hey guys,

I need help about using two date slicer to know the aging of account receivable.

I have 2 table just like this:

- Invoice data

- Paid data

I wanna know the AR (account receivable) aging based on the due date. there are 4 categories which are:

- aging 0-30 days 

- aging 31-60 days

- aging 61-90 days

- aging more than 90 days

So when the first date slicer is set to 1 august 2018, all duedate invoice transactions for the period of July should be aggregated in a column called 'aging 0-30 days', for duedate in June, which is more than 30 days from 1 august 2018, should be aggregated in a column called 'aging 31-60 days', etc.

In report should show table like this:

AR aging invoice

For paid table, it is linked with invoice table, so i want to show aging paid table based on duedate in invoice table. Basically the second report table is just like the first table in AR aging invoice, but the categories are follow the duedate, not the paid date. The second slicer in here is use to set the date based on paid date.

Example, the second slicer is set to 31 august 2018. So all data in paid table which more than that is filtered, only the data that below 31 august 2018 are selected. Then, the paid data should be aggregated in a column called 'aging 0-30 days', and other categories based on the invoice just like report table in AR aging invoice

AR aging paid

I already made two calendar tables, but i cant make this scenario, can you help me?

Thanks. (sorry for my bad english)