Hi Gerald,
The issue I had was grouping the results by quarter/year. What I did was add a cc with the following formula:
=IF(MONTH([Closing Date])<=3,"Q1",IF(MONTH([Closing Date])<=6,"Q2",IF(MONTH([Closing Date])<=9,"Q3",IF(MONTH([Closing Date])<=12,"Q4",""))))&" "&Year
Then for my X Axis I set the field name to be the cc. Hope that helps!
Message was edited by: Stephens-s
I forgot to mention that the Year at the end of the formula is for another cc that I am using for another chart. You could replace that with YEAR([Closing Date])