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