Pivot Tables - Dividing Output in Table by a Constant

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gmccaffrey@acutus.co.uk - 19 Mar 2008 14:50 GMT

I am trying to divide my pivot table output by a constant (which is
5.05). The tabulated output is summarised by the "Sum" function which
has been selected in the PivotTable Field dialogue box. I have invoked
Options and examined the further dropdown selections from the "Show
Data As" and "Base Filed" options - but I am lost.

What I am trying to achieve is so simple, but it defeats me. Of couse
I can divide my base data by the constant - but I dont want to do
that. I was hoping the resultant pivot table could be produced such
that ir could divide the values it returns by 5.05.

Thanks in Advance.

Reply to this Message

Leo Rod - 19 Mar 2008 21:43 GMT

Standing over the pivot table data area do this:

Menu: Insert
Select item: Calculated field

Name:Field1 <-- Default, can be changed to whatever you want for the name,
it will be the column title.
Formula: ="pivot table output"/5.05 <- select the pivot table output field
from the list underneath of this field and divide it by your constant.
Click Add

Then from the 'PivotTable Field dialogue' box add the new field you just
created.

Greetings

Leo Rod
Miami, Fl.

>I am trying to divide my pivot table output by a constant (which is
> 5.05). The tabulated output is summarised by the "Sum" function which
[quoted text clipped - 8 lines]
>
> Thanks in Advance.

Reply to this Message

Rate this thread: