Calculated Field based on 2 Running Totals in PivotTable

[InfiniteJoy]

I need to create a calculated field in a pivot table that would be the
ratio of two running totals already in my pivot table. I would like
to avoid doing the calculation in cells outside the pivot table.

Here is how my data needs to look and I am unable to get the ratio
calculated:

Week Running Total 1 Running Total 2 Ratio
1 2
3 0.67
2 5 10
0.50
3 7 21
0.33
4 10 40
0.25

 

[Héctor Miguel]

hi, !

I need to create a calculated field in a pivot table that would be
the ratio of two running totals already in my pivot table.
I would like to avoid doing the calculation in cells outside the pivot table.
Here is how my data needs to look and I am unable to get the ratio calculated:
Week Running Total 1 Running Total 2 Ratio
1 2 3 0.67
2 5 10 0.50
3 7 21 0.33
4 10 40 0.25

op1: see Debra's Excel - Pivot Tables - Custom Calculations:
-> http://www.contextures.com/xlPivot10.html

op2: you will need the helper column

hth,
hector.

 

[InfiniteJoy]

I already know how to create the Running Totals in a Pivot Table.

I am asking how to make a calculated field from those two Running
Totals without having to resort to a helper column outside the Pivot
Table.

 

[Héctor Miguel]

hi, Chris !

I already know how to create the Running Totals in a Pivot Table.
I am asking how to make a calculated field from those two Running
Totals without having to resort to a helper column outside the Pivot Table.

you never "show" to us how your PT layout looks-like (so, just in case)...
if you have only 2 "data-items" in a "2 rows arrangement" PT -?-
be sure your PT layout is (or can be) accomodated like this one:
-> Excel - Pivot Tables - Data Field Layout
http://www.contextures.com/xlPivot02.html

now, you will be able to add/formulate/... your custom calculated field

if any doubts (or further information)... would you please comment ?
regards,
hector.