1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/FreshBusy1
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#intelligent data visualization
#rows.com
#pivot table
#Excel
#group dates
#filter by date
#data set
#revenue
#month
#year
#quarter
#individual dates
#fields