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

	Delivered	Ontime	Ontime%
JAN	=Pivot count finished	=Pivot count ontime	=Ontime/Delivered
FEB	138	123	89,1%

<tbody>
</tbody>

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.