Cross Tab by Year and Month

einstein2004
einstein2004 used Ask the Experts™
on
Hello,
I'm trying to build a cross-tab based on totals by month in rows and years in columns.  However, my rows repeat with each year.  For a 12-year period, there are 144-months.  The report is grouped by ticket date [year] then ticket date [month].  How do I get all 12 Augusts to line up?
Thanks much. screen shot
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Try this

Add this formula and use it for the rows in the cross tab
Month({YourDateField})

mlmcc

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial