cross-tab question

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"]
[DayOfWeek({Orders.Order Date})]

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?
ylecoyoteAsked:
Who is Participating?
 
DRRYAN3Connect With a Mentor Commented:
ylecoyote

Your formula for week is just fine.  Right click on your crosstab, choose Format Cross-tab.  Be sure the Cross-Tab tab is active.

Click on the @Week in the Columns box.  It should be the only field/formula listed.  Click on Group Options button.  The first drop down should be set to read In Specified Order.  When you make that selection, the "specified order" tab becomes active.  It is here that you made your mistake.

You should see the 7 days of the week listed in the drop down control, and initially nothing in the scrolling list.  From the drop down, select each day of the week in the order in which you want them displayed.  All 7 days should be listed in the scrolling listbox when you are done.

OK and SAVE your way out of the dialog boxes and preview your crosstab again.

DRRYAN3
0
 
ylecoyoteAuthor Commented:
Thank you! I don't know how I missed that.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.