Hide column in PivotTable

[k.roberts]

Hiya, I have a PivotTable as a subform and wish to hide the Grand Total
column completely - how do I do this? I have already unticked the
'Always Display Empty Columns' option with no effect.

 

[Vincent Johns]

Well, one easy way would be to open it in Query Design View and de-check
the column that displays the Grand Total. (That makes it invisible, and
if it's not used anywhere else, it will be erased when you close the Query.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Vincent Johns]

Oops -- Crosstab Queries don't include a Hide Me check box, so I guess
you just have to delete the column you don't want included. (I'm sorry
if I misled you.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[k.roberts]

Thanks but I don't have the option to delete it. When right clicking
on the column, the option Remove is greyed out.

 

[Vincent Johns]

Thanks but I don't have the option to delete it. When right clicking
on the column, the option Remove is greyed out.

Well, OK, then just build another Query based on the Crosstab Query and
include only the columns that you want to see. This will also give you
other options, such as sorting, filtering, and renaming columns.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.