Skip to Content
0

Cross Tab Column Groupings

Dec 11, 2017 at 09:03 PM

39

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dell Stinnett-Christy Dec 11, 2017 at 09:59 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Dec 12, 2017 at 07:29 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded