Cross tab 'Suppress Row Grand Totals' doesn't seem to work

[ValerieH]

I have a relatively simple cross tab showing data by month from two different financial years. The total of those columns doesn't make sense and my client doesn't want to see it. I have used the Cross Tab Expert and checked 'Suppress Row Grand Totals' but the column still appears.

I have also tried using the Format Editor to suppress both the values and the text, and that works, but now I have a blank column. Checking 'Suppress Empty Columns' does not get rid of it.

Any suggestions would be appreciated.

 

[lbass]

Try 'suppress column grand totals'. The suppression of row/column grand totals has always worked for me, so I'm guessing you might have checked the wrong one.

-LB

 

[ValerieH]

I found out what I was doing wrong. The cross tab was set up with two column categories, e.g.

Main_header
Sub1 Sub2

I was only interested in Main_header records, but wanted to have the name there, because it might change from one client to another. So I had set it to Discard all others.

So even though I was seeing a total of Sub1 + Sub2, what I was actually seeing wasn't a Column Grand Total at all, it was the Group sub-total. So to get rid of that I just had to:
- run the Cross Tab Expert
- select the 'Customize style' tab
- select the Main_header name under Columns:
- check 'Suppress Subtotal' box under Group Options

So in case anyone else ever has this problem, the solution is documented.