Adding Calculated Field with multiple Columns

[alphabo1201]

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>

 

[alansidman]

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)