Pivot table and ADD calculated field

[prehisto]

Hello,guys!
So i Have this PowerPivot and I want to add a new calculated field which consists of formula which is made of cells of this powerpivot.
PowerPivot looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Row labels[/TD]
[TD]sum of fee[/TD]
[TD]Sum of obj.[/TD]
[/TR]
[TR]
[TD]2007 Q1[/TD]
[TD]1079963446[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]2001 Q2[/TD]
[TD]101862069[/TD]
[TD]248[/TD]
[/TR]
</tbody>[/TABLE]

So the calculated field should contain formula ='sum of fee'/'Sum of obj.'.
The problem is that when i open '' calculated field '' option in the "field'' section there is no 'sum of fee' and no 'sum of obj. '.
I'm confused because when i watched some tutorials , they had analogue column names there

 

[RoryA]

You have two options. You can simply create a measure that is =SUM(fee)/SUM(obj) or you can create measures for each of SUM(fee) and SUM(obj) and then create a third measure that divides the first two measures. The latter option will give more flexibility should you need to change the calculation of one or both of the source measures later on.

 

[prehisto]

You have two options. You can simply create a measure that is =SUM(fee)/SUM(obj) or you can create measures for each of SUM(fee) and SUM(obj) and then create a third measure that divides the first two measures. The latter option will give more flexibility should you need to change the calculation of one or both of the source measures later on.

Hi, first of all-thank you for answering.
But i do not quite understand what you meant to say.

Are you suggesting that , i manually calculate the values like below?

Excel 2013
[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH]_Row\^Col[/TH]
[TH]

A​

[/TH]
[TH]

B​

[/TH]
[TH]

C​

[/TH]
[TH]

D​

[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

4​

[/TD]
[TD="bgcolor: #DDEBF7"]Row Labels[/TD]
[TD="bgcolor: #DDEBF7"]Sum of fee[/TD]
[TD="bgcolor: #DDEBF7"]Sum of Obj.[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

5​

[/TD]
[TD]2007 Q1[/TD]
[TD]

107996346​

[/TD]
[TD]

222​

[/TD]
[TD]='B5'/'C5'[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

6​

[/TD]
[TD]2007 Q2[/TD]
[TD]

101862069​

[/TD]
[TD]

248​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

7​

[/TD]
[TD]2007 Q3[/TD]
[TD]

123644314​

[/TD]
[TD]

315​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

8​

[/TD]
[TD]2007 Q4[/TD]
[TD]

49838667,34​

[/TD]
[TD]

218​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

9​

[/TD]
[TD]2008 Q1[/TD]
[TD]

44624727​

[/TD]
[TD]

174​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

10​

[/TD]
[TD]2008 Q2[/TD]
[TD]

129858446​

[/TD]
[TD]

218​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

11​

[/TD]
[TD]2008 Q3[/TD]
[TD]

129956950​

[/TD]
[TD]

267​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

12​

[/TD]
[TD]2008 Q4[/TD]
[TD]

114052233,9​

[/TD]
[TD]

203​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

13​

[/TD]
[TD="bgcolor: #DDEBF7"]Grand Total[/TD]
[TD="bgcolor: #DDEBF7"]

801833753,2​

[/TD]
[TD="bgcolor: #DDEBF7"]

1865​

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: pivots[/TD]
[/TR]
</tbody>[/TABLE]

And then somehow add it to pivottable?

 

[RoryA]

No, I'm saying you right click the table in the Power Pivot field list, choose 'Add new measure...' and then create the measures I mentioned. You can then use them directly as part of the pivot table.