Pivot - Division of Columns

[faisus]

Hi all. I would like to know how to put a formula in calculated field in pivot values for a count. Attached image will give you an idea as i need the orange highlighted result in pivot by putting formula so i can filter by branches and many more.

Here i have to do manually outside table.


Thank you

 

[RoryA]

What are those percentages supposed to be?

 

[faisus]

What are those percentages supposed to be?

The Percentages under I column are E6/B6 & under J column is F6/C6

 

[RoryA]

Ah OK. I think you'd have to create a calculated item (not a calculated field) that is ='Renewal' / 'New Policy'

 

[faisus]

Ah OK. I think you'd have to create a calculated item (not a calculated field) that is ='Renewal' / 'New Policy'

Thank you. I have got it.