Filtering Summarized table from main table using daterange from the orignal table

I have an order table with sales of products from different dates (table A). I have created a summarized table, grouped on location and product. Now I want that if I use a date range slicer from table A, I want the summarized values from table B to change.

I tried passing SelectedValue, but it is not authorized.

How can I achieve this?

Alternatively, is there any other way through which I can create summarized temporary table somewhere on changing date range, because I need to count the number of rows from this summarized table.