Quarterly Crosstab - Help Please 1

[Cort]

Using v9.0

OK there is this lovely option in the crosstab expert to group by Quarter. However, I cannot find any option to name the field by quarter. Am I missing something here? Is there a way for my to have the x-tab group names say 1st Qtr, 2nd Qtr, etc instead of Jan, Apr, etc?

Thanks

 

[Cort]

Well I got it to working. FYI here is the formula I used. If anyone knows a way that CR does this automatically please Pipe up.

Thanks

if Month({date_field})in 1 to 3 then "1st Quarter 2003" else
if Month({date_field}) in 4 to 6 then "2nd Quarter 2003" else
if Month({date_field}) in 7 to 9 then "3rd Quarter 2003" else
if Month({date_field}) in 10 to 12 then "4th Quarter 2003" else
"error"