add one more column to pivot table

[#1]

in pivot table I have won and total columns their I need to calculate the %column add to pivot table  means won/total =% column how to calculate the % column after generate the pivot table

[tresesco]

=[LabelofOwnCol] / [LabelofTotalCol]

Then in the number tab, check 'Show in Percent(%)'

[#3]

hi

in expression

= won / total

the  proprties , number tab, check 'Show in Percent(%)'

[#4]

this is the pivot table

mnt   status   lst   nd   rec  won  total

jan                  1      1     1       1       4

feb                   1     2     1      2       6

after generate the pivot table like this than after add other column to the pivot like % column like won/total.

total column also one expression column. 

[#5]

any one explain me...plz

[#6]

may this help you,

sum({<status={'won'}>}Value)/sum({<status={'total'}>}Value)

replace Value with your field..    

[#7]

apply this one but  the % column add every status column I need only one column after the total any one plz explain me

[SunilChauhan]

column(m)/column(n)   m is the no of won Column and n is no of total column

PS:  first  expression in chart is known as column(1) ,second is column(2)....so on

hope this helps

[#9]

could you post your sample application..

[tresesco]

May be like attached sample?