Pivot question about sums

[Guest]

I have 3 columns in my pivot report that have time (in Minutes) in them, I
want them to total up, but only at the bottom of the column and not after
every entry, is there a way to make this happen? I have other columns that I
don't need a sum for but at the bottom of every column it shows (blank) is
there a way to show only the sum once for the three columns I need sums for
and not show the (blank) on the columns I don't need a sum for? You might
want to know that each of these rows are for clients. The columns show the
activate for each client.

 

[Roger Govier]

Hi

Double click on each of your fields in the Row area, and set Subtotals
to None.
To remove the Blanks, select the dropdown for the appropriate filed and
de-select Blank.

 

[Guest]

Great that works.... in a minute i am going to post another question... I
am loving the pivot table, but it does so much, and i know it will do what i
want it to do, but i am having lots of trouble looking up the right type of
"help" when i get stuck.... Thank you,