Creating Dynamic Date Slicers to Calculate Sum of Amount

[MarziehAdineh]

Hello
I would appreciate it if someone could help me with the following question.

I want to have four slicers to determine the date selected by the users according to the conditions in the following image. The slicers take the date from the corresponding column (SCHEDULE_DATE, DUEDATE) by the user selection and calculate the sum of the CERTIFIED AMOUNT. Finally, the output should be a table with four columns, each column representing the calculated value based on each of the slicers.
Thanks.