How to order Cross Tab summarized data?

bsolnek

I've got:
1) Data Set that returns the day and day number of transactions for store locations ordered by day number
(e.g.
Austin, Mon, 2
Camden, Mon, 2
Camden, Mon, 2
Austin, Mon, 2
Camden, Tue, 3
Austin, Tue, 3
Austin, Tue, 3
Austin, Wed, 4
Camden, Thu, 5
Camden, Fri, 6)
2) Data Cube with Group of Location, Day and Summary Field of Day(Count)
3) Cross Tab to display the data.

When this is run the Summary field is ordered alphabetically instead of by the data set order (i.e. Fri, Mon, Thu, Tue, Wed).

I've experimented with combining the Day Number and Day (i.e. 2_Mon, 3_Tue, 4_Wed...) which results in the desired display order but with the messy looking combined notation.

So, is there either a way to get the original query to display as ordered, or a way to strip out the leading 2 characters of the combined values while retaining the order???

mwilliams

Hi bsolnek,

You can always just make them 2, 3, 4, 5, and 6 and replace the value in the crosstab header in the script with an if statement. (i.e. if 2, then "Monday", etc.)

Hope this helps.