I'm fairly new to crystal. I've created a cross-tab using region as the row field and @week as the formula for the column field. Order amount is the summary field. My @week formula is:
["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"]
I grouped by @week and in the cross-tabs group options dialog box I chose specified order. There was nothing to choose from in the speicifed order tab list box, which I thought was weird so I typed each week in one at a time allowing for any value.
After doing all this, I got a report that only showed the region amounts for Monday and a second column showing the total. What i wanted was each week across the page and the total. What did I do wrong?