Filtering table before grouping using date slicer

Hi Anonymous 

Consider a case of say a shop.
There is a master table with unique orders, say table A.
So its 1 entry per order in this table.

There is also another table B, where transactions per order can be captured.
In the transcation table, multiple payments can be paid against that order, each payment done on a specific date.

In table A, its a master record of the order so there could be up to 10 columns of information about an order in table A.
Table A will be the main data table where we show all of its information in our report.
We need to bring in the aggreagated sum of amount from table B to enrich main table A.

Before we aggregate the data in table A, we need to filter out based on a date range.
Therefater, the aggregated sum of each order should then be joined to table A.

This combined data of all columns of A and the aggregated sum of orders in B then forms our report.
So its a left join of A and B 
A is also date filtered, since the records in it have a date range, B is also date filtered, so that we get transactions for an order in A only from a specific time period.

Thanks