Microsoft Office Forums - View Single Post - [Solved] Group Date by Quarter in PIVOT TABLE

Thread: [Solved] Group Date by Quarter in PIVOT TABLE

View Single Post

Old

04-23-2014, 11:08 PM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs has a spectacular aura about

Default

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.

Reply With Quote