Adding Calculated Field with multiple Columns

alphabo1201

New Member
Hello,

Is there any way to create a calculated field when there is multiple columns in pivot table?
there is two fields inserted in to column section and use the number from there to create calculated field.

I am trying to create Rev Prod- cost 1 field.

For example: Data would look like this
 Name overall Detail Net a Revenue Rev ser 10 b Revenue Rev Prod 10 a cost cost 1 5 b cost cost 3 3 e G&A G&A 5 f G&A G&A 5 g ETC ETC 1

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

Once pivoted:

 Sum of Net Column Labels Revenue cost ETC G&A Row Labels Rev Prod Rev ser cost 1 cost 3 ETC G&A a 10 5 b 10 3 e 5 f 5 g 1 Grand Total 10 10 5 3 1 10

<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

alansidman

Well-known Member
 v A B C D E F G H I J K L M N 1 Name overall Detail Net 2 a Revenue Rev ser 10 Sum of Net Detail 3 b Revenue Rev Prod 10 Name overall cost 1 cost 3 ETC G&A Rev Prod Rev ser 4 a cost cost 1 5 a 5 b cost cost 3 3 Revenue 10 6 e G&A G&A 5 cost 5 7 f G&A G&A 5 b 8 g ETC ETC 1 Revenue 10 9 cost 3 10 e 11 G&A 5 12 f 13 G&A 5 14 g 15 ETC 1 16

Name and Overall in rows
Detail in Columns
Net in Valuses (sum)