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.
--
thank you, Lorie

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.

--
Regards

Roger Govier


"Lorie" wrote in message
...
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.
--
thank you, Lorie

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,
--
thank you, Lorie


"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"Lorie" wrote in message
...
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.
--
thank you, Lorie