Pivot table probelmq

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arne Hegefors - 30 Oct 2007 11:08 GMT

Hi! I have a pivot table in which I use two different field types as columns
(eg Beverage type and Brand). In my table I just want to show these columns
but Excel instits on showing a Total column for each beverage type. I have
tried to get rid of this but it seems impossible. Is there any way of
removing the Total column?

Reply to this Message

Ken Wright - 30 Oct 2007 20:41 GMT

Either right click on the field, choose field settings and where it says
"Subtotals", just click on the option that says "None".

Or, if by any chance what you rae seeing is Table Totals, then right click
on the table, choose "Table Options" and then just untick the "Grand Totals
for Columns" option.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

> Hi! I have a pivot table in which I use two different field types as
> columns
[quoted text clipped - 3 lines]
> tried to get rid of this but it seems impossible. Is there any way of
> removing the Total column?

Reply to this Message