Excluding row totals in crosstab

[laurie987]

I have a crosstab built, but need to exclude the total row on one of the columns. How do I do this. I tried suppressing the line but it still leaves a gap when I export to excel.
Thanks!!!!!

 

[vxxv]

Hi Laurie,

There is a check box in the Cross-Tab properties that can do what you need. In the field in question you can uncheck the total.

Regards
vxxv

 

[skries]

In Format Crosstab, under the 'Customize Style' tab highlight the appropriate row that you want to suppress and check the box under Group Options 'Suppress Subtotal'