Crosstab totals

[Former Member]

The typical crosstab looks like this:

Group A

team a

team b

Group B

team a

team b

Total

I want a crosstab that looks like this:

Group A

team a

team b

Group B

team a

team b

Total

team a

team b

How do I get there?

[former_member260594 · Accepted solution]

Tim,

You might be able to use nested suppression formulas along with display string formulas and dummy summaries to do this but it might be easiest to just use 2 crosstabs. The first one would consist "the typical crosstab" the second would be in a subsection below where the rows are based just on team.