Group Date by Quarter in PIVOT TABLE

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:07 AM.