ameliaETL06-14-2022SolvedFiltering until last week 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 d...Show Moreharikm00706-15-2022Hi amelia , Please try this advanced filter. -Hari
ameliaETL to harikm00706-15-2022Thanks 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 harikm007Data Warehouse to amelia06-16-2022This is to filter last 1000 weeks. If you need to filter 100 weeks including current week, set count as 100 and offset as 0ameliaETL to harikm00706-17-2022Thanks Hari!!
ameliaETL to harikm00706-15-2022Thanks 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
harikm007Data Warehouse to amelia06-16-2022This is to filter last 1000 weeks. If you need to filter 100 weeks including current week, set count as 100 and offset as 0
Recent DiscussionsColumn Chart Break By Max No SeriesPivot Table widget - column headers and column data out of alignmentBlox conditional formatting up and down indicatorsRemove Widget Title BoxSolvedChange Legend Category Names
