Group Date by Quarter in PIVOT TABLE

		Microsoft Office Forums > Microsoft Excel > Excel
Group Date by Quarter in PIVOT TABLE

FAQ

Thread Tools

Display Modes

04-23-2014, 11:08 PM

gebobs

Windows 7 64bit Group Date by Quarter in PIVOT TABLE

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

I think you would have to do a calculated column, call it quarter. An easy IF statement based on the date. Then have that one of your row or column headings.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Group Table Rows/Column (like Excel Group)	eoinymc	Word	1	03-11-2014 04:51 AM
Pivot table date grouping	differentdrummer	Excel	2	12-04-2013 03:07 PM
Conditional Mail Merge per Student and Quarter	marysilvaramos	Mail Merge	1	01-29-2013 07:17 PM
Make table cell active add date count date	MelHerndon	Word VBA	3	01-21-2013 04:23 PM
Pivot table help	TishyMouse	Excel	2	04-27-2012 10:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 PM.