Pivot Tables - Dividing Output in Table by a Constant

  • Thread starter Thread starter gmccaffrey
  • Start date Start date
G

gmccaffrey

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