Filtering until last week

[amelia]

Hi! I am creating a pivot table and I currently have all the values populated until the end of this year. However, I would only like to include values up until the previous week, which is a dynamic date. Is there an advanced filter I could use that would help with this? Thank you so much 😄

[harikm007 · Accepted solution]

Hi @amelia ,

Please try this advanced filter.

-Hari

[amelia]

Thanks Hari! Can I ask, what does the count:1000 part of the filter do? It works, but I just want to understand what the script is doing here 

[harikm007]

This is to filter last 1000 weeks. If you need to filter 100 weeks including current week, set count as 100 and offset as 0

[amelia]

Thanks Hari!!