Calculate Data Field To Data Field in Pivot Table?

  • Thread starter Thread starter Ronster
  • Start date Start date
R

Ronster

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
 
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
Click to expand...


Thanks Debra. This has been very helpful.
 
Back
Top