Skip to Content
avatar image
Former Member

Cross Tab Column Groupings

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 11, 2017 at 09:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 12, 2017 at 07:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded