Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.