Cross Tab Column Groupings

[julie_jamieson2]

I want to create a pretty standard Cross Tab to show Units & Sales over months. The issue is they want to show Units in columns, then a total, then amounts in columns, then a total.

How can I get column groupings to do this?

[abhilash_kumar]

Hi Julie,

You could use two crosstabs - one for Units and one for Sales.

Place them beside each other and then go to the Section Expert > Highlight the section that holds the Crosstab > Check 'Relative Positions'.

This makes sure that the crosstabs don't overlap each other.

If you need the second crosstab's 'Row' field to be hidden, you'd need to right-click the Row field > Format field > Check Suppress. You'd also need to reduce the field's width so that it isn't taking up unnecessary space. It isn't going to look very pretty, however, this should be pretty close to what you're after.

-Abhilash

[DellSC]

Is this format horizontal?

Units per month Total Units Sales per month Total Sales

Or vertical?

Units per month
Total Units
Sales per month
Total Sales

Vertical is fairly easy using two cross-tabs. Horizontal is not doable using just what's built in to Crystal. Instead, you would have to use a Command (SQL Select statement) where you pivot the data by month and do the totals so that you have a single row of data for each row that you want to appear on the report. It can be a challenge to get the query correct, but I have been able to do it before, so I might be able to help you with it if this is what you need.

-Dell