How do I group dates in a pivot table by year or month, or both?
My first post got deleted because of the title or something. Anyway, in case anyone is seeing this for the second time, this is the same description as before. This is for a college assignment. The assignment gives me a huge data set (about 6000 values). The video given directs me to insert a pivot table and first filter by date (put to columns) and revenue (values). I do this and the video tells me that excel should automatically group all values by month, quarter, and year, but it doesn't, it just lists out every single individual date that a data entry occurs on. I've looked at several posts online about how to do this and tried several different things, but I'm getting sidetracked and I am kind of lost. In the video there are fields for quarter and year, but not when I do it. There is only one for individual dates. Does anyone know why? Hopefully I didn't say that in a confusing way.
[link] [comments]
Want to read more?
Check out the full article on the original site