'Dynamic "Filter by Condition" in Pivot
i have a pivot table often required to adjust date range which up to 6 different dates from column A1 to A6. What kind of formula should i use in the "Filter By Condition" > "Custom Formula" based on the date references in A1:A6 so that i don't have to go to filter and select and deselect the date whenever i need the data? Appreciate your help here.
Updated: Google Sheet Trix here
Solution 1:[1]
Use this formula to filter data based on the dates that you need and then construct a pivot table from there:
=FILTER(A2:F, MATCH(A2:A, N2:N7,0))
Note: N2:N7 is the range of the dates that you want to filter. You may need to edit that range based on where you have that data.
The best way I found to achieve what you're looking for was filtering data first, then create a pivot table on the results.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Lorena Gomez |