Filtering by Start of Week data

Hi Jake,

Thank you for your question in STL's forum.

From what you described I believe you have gone through the right process to determine every date's start of week date in the duplicated column.

If you now build a pivottable use the duplicated column with the weekly start dates to the row area of the pivottable then that should show you each week's start date (right click on any year's value and select 'Ungroup). If you add a fiwld to values section it should summarise all the dates' values that fall within the same week.

Now instead of adding the field to the filter section of the pivottable, try using a slicer and add the duplicated column with the start of week dates to the slicer you will be able to filter on the start of week dates.

I attached an Excel file with an example.

If this answers your question, would you please mark it as resolved?

Thank you

Ron Oldeboom