Is it possible to create a formula that calculates one data field to
another inside a pivot table? For example if I create a SUM in the
data field, can I multple that SUM times a percentage in another data
field? Is this too simple?

You can create a calculated field in a pivot table, and it will use the
Sum of underlying values for each field in the calculation. So you could
create a formula that includes a percentage, e.g.:

=Field1 * Field2 *.05

Ronster wrote:
> Is it possible to create a formula that calculates one data field to
> another inside a pivot table? For example if I create a SUM in the
> data field, can I multple that SUM times a percentage in another data
> field? Is this too simple?
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

On Mar 1, 5:11 pm, Debra Dalgleish <d...@contexturesXSPAM.com> wrote:
> You can create a calculated field in a pivot table, and it will use the
> Sum of underlying values for each field in the calculation. So you could
> create a formula that includes a percentage, e.g.:
>
> =Field1 * Field2 *.05
>
> Ronster wrote:
> > Is it possible to create a formula that calculates one data field to
> > another inside a pivot table? For example if I create a SUM in the
> > data field, can I multple that SUM times a percentage in another data
> > field? Is this too simple?
>
> --
> Debra Dalgleish
> Contextureshttp://www.contextures.com/tiptech.html


Thanks Debra. This has been very helpful.