Hello,
I couldn't really describe this in an "Easy" language, as my first language is not English, but I'm having some trouble using Date as variables.
So I have this data set:
excel1.png
Notice that everyone buys Product #1, but not everyone bought Product #2.
From this, we get our regular pivot table:
excel2.png
Now, what's the problem?
I can't change the dates at will! What if I want to do any dates between 1/1 and 2/28 for Product 1 purchase dates? Yeah, on a small data set we can individually uncheck based on filter, but on a big data set that won't be possible.
This is what I'm looking to do:
excel3.png
I'm so sorry if it doesn't make complete sense - I'll be more than happy to clarify confusion.
I would appreciate any help in this matter and thank you for reading!
Bookmarks