Hide column in PivotTable

K

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.
 
K

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.
 
V

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.
Click to expand...

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.
 
Top