Pivot question about sums

  • Thread starter Thread starter Guest
  • Start date Start date
G

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