Pivot table probelmq

[Guest]

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?

 

[Ken Wright]

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.

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

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------