Pivot, calculated column

[KongGulerod]

Hi

I have a pivot. Row names are months
COL1 is number of delivered
COL2 is number of delivered on time

How can i add a 3rd column that calculates COL2/COL1.
The third column has to work like the other so a new calculated field appears when data from march is added to the dataset.

Example

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Delivered[/TD]
[TD]Ontime[/TD]
[TD]Ontime%[/TD]
[/TR]
[TR]
[TD]JAN[/TD]
[TD]=Pivot count finished[/TD]
[TD]=Pivot count ontime[/TD]
[TD]=Ontime/Delivered[/TD]
[/TR]
[TR]
[TD]FEB[/TD]
[TD]138[/TD]
[TD]123[/TD]
[TD]89,1%[/TD]
[/TR]
</tbody>[/TABLE]

I have tried with calculated field but can not make it work as i want it.

Kind regard KG

 

[krogh101]

Hi,

What do you mean when you say that you cannot get the calculated field to work as you want?
It seems to work when i try it.

 

[KongGulerod]

Hi,

What do you mean when you say that you cannot get the calculated field to work as you want?
It seems to work when i try it.

I guess you are right.
Because any calculated fields I add either gives a "0" or a "division by 0" and neither is correct.