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

I don't follow what you are trying to describe. How about providing us with a small sample set. Manually type an example of the results you want to see.

Off hand, yes, you can create different columns of calculations on the same dates.  Just drag a second copy of the column you want to work on into the values area.

.

For example I have used the sales column to create 2 different calculations. Is that what you want to do, but on a date basis?

Answer 3

Ignore the second pivot in the bottom corner of the screen cap.

Upload Example - Trouble Shooting - Share Personal OneDrive File (not Business OneDrive)

.

Trouble shooting problems in files can be like a visit to the dentist, a long, slow painful process of us trying to “extract” the clues needed to recognize the problem in a back and forth flow of questions and answers so that we can come up with a / “the” solution.

.

Often it is faster and easier for everyone if we have a “sample file” get "hands on", to look at, and to “play with”.

.

This next link provides some tips on setting up a sample file and specific instructions for uploading and "sharing" it for us to access:

.

https://answers.microsoft.com/en-us/windows/forum/windows_other-winapps/trouble-shooting-share-onedrive-file/a231a097-bcbf-4e34-ad6c-a33118baf471

.

Answer 4

Thanks, Rohn007, for the link. It'll be better to provide a sample, will keep posted.

Answer 5

Hello HelluvaEng19

I am V. Arya, Independent Advisor, to work with you on this issue. Post the sample to Onedrive and share the link here. Don't post any confidential data.