Help...need direction. I need to produce a report that will calculate quarterly activity based on a fiscal or hire date year. This is a Annual Scorecard report based on start date. Using CR11.
My current report calculating the quarters by using the group options per quarter. I need a way to calculate or define the quarter based on the start date. Or remove the group options and come up with a formula that will calculate 3 months at a time to provide quarterly totals.
Is there a way to define the quarterly group option or a better way to get a quarterly sum based on the parameter of the report date. I don't know if this is possible or how to do it. Hope this makes sense. If you need more information please let me know.