cancel
Showing results for 
Search instead for 
Did you mean: 

Filtering until last week

amelia
10 - ETL
10 - ETL

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 😄

1 ACCEPTED SOLUTION

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @amelia ,

Please try this advanced filter.

harikm007_0-1655313543332.png

-Hari

 

View solution in original post

4 REPLIES 4

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @amelia ,

Please try this advanced filter.

harikm007_0-1655313543332.png

-Hari

 

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
13 - Data Warehouse
13 - Data Warehouse

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

Thanks Hari!!