Excel Pivot Tables: Single Timeline for Multiple Date Columns

Question

Hello,

Is there a way to create a single timeline filter for Pivot Tables that applies to each date column independently for counts? In other words, have the user select a month and year, which gets applied to multiple date columns without the need to create multiple timelines.

For example, a count of the first date column is filtered by January 2020, another count has the second date column filtered by January 2020 independently, and so forth.

Thank you.

Answer 1

Unfortunately, the filters in Pivot generate an AND condition. What you require is an OR condition which is not feasible in Pivot. It will not be possible to combine Timelines to create an OR condition.

Answer 2

Hi,

You may download my solution workbook from here.

Hope this helps.