Hmmm... then do you have any other suggestions of ways I might go about
getting this information?

The problem is that I need to sum the group, then perform this action. I
don't think this will work for that. Plus, I have eight columns do this on
for each group.

"Roger Govier" wrote:

Only by making the calculation as another column in the source data, and
then just including that column in the PT.

--
Regards

Roger Govier


"adodson" wrote in message
...
Is there a way to get it to show without it being another column?

"Roger Govier" wrote:

Hi

Bring up the PT Toolbar.
From the dropdown select FormulasCalculated Field
Give the new field a suitable title and in the formula pane enter
your
formula
=Ceiling(Floor(number, 1),5) replacing number with the name of the
filed already included in the PT that you are trying to round in this
way.


--
Regards

Roger Govier


"adodson" wrote in message
...
Ok, please forget the above message. I figured that out. My real
question
is, is there a way to use the ceiling/floor functions on the totals
in
a
pivot table?

For example, I often use the formula: Ceiling(Floor(number, 1),5)
However, I don't see where to enter a formula such as this when
using
the
pivot table.

Again, assistance is appreciated. Thanks!