Timeline Not Matching Other Filters
Hello all,
I tried to find a similar topic discussion on here but have not seen one. I currently have a pivot table with a few sliders and one timeline filter. One of the filters is a “Six Month” filter, which shows items that are due for review within the next 6 months. This filter is from a column on the original table that shows either “Six Months Review” or “Do Not Need to be Reviewed” and is based off a formula of a date column. My issue is, when I click to filter on “Six Months Review”, the date timeline doesn’t filter on those 6 months, it still shows all the dates present in the table. Is there a way for the Timeline filter to show data based off of the other filters as well?
Would appreciate any insight at all, thank you!
Hello all,I tried to find a similar topic discussion on here but have not seen one. I currently have a pivot table with a few sliders and one timeline filter. One of the filters is a “Six Month” filter, which shows items that are due for review within the next 6 months. This filter is from a column on the original table that shows either “Six Months Review” or “Do Not Need to be Reviewed” and is based off a formula of a date column. My issue is, when I click to filter on “Six Months Review”, the date timeline doesn’t filter on those 6 months, it still shows all the dates present in the table. Is there a way for the Timeline filter to show data based off of the other filters as well? Would appreciate any insight at all, thank you! Read More