Showing 2 weeks Dates on pivot based on selection

[ngrunoz]

I have data ranging over periods of time and I would want my pivot chart to alway show a maximum number of date values limited to 14 days (2 Weeks) but based on calender weeks.

if i select  17/01/2019  chart should display from 12/12/2018 - 12/01/2019

if I select 10/01/2019  chart should display from 06/01/2019 - 19/01/2019

If no selection default should be current week plus last week.

[agni_gold]

You can create 2 variables for min & max date based on your date selection, and use these variables in set analysis.