Label Filters in Pivot Table

[froggiebeckie]

I have a pivot table that returns a sum value (number of days) per week number (formatted as 2019-23)

I need it to only show weeks for the past year, so basically >(This week -51).

I've tried setting the filter, using NOW() but can't it to work.

Any suggestions?

Thanks,
BeckieO

 

[SpillerBD]

I am guessing that your week number is not a formatted date, but a Text value.
You could use a date value, but there isn't really a built in filter based on weeks.
However, you can have a filter or slicer that can be updated with a macro and connected to a calculated date that is the equivalent of -51 weeks.

 

[froggiebeckie]

Thanks, I'll lot at the slicer.