% column problem in pivot table

[#1]

Hi,

Actually  my problem is i have .qvd  data. data the used to generate the pivot table like this

month	lost	nodecision	won	grandtotal
jan	40	30	3	73
feb	45	35	4	84
mar	65	45	5	115
grandtotal	150	110	12	272

but i need this type

month	lost	nodecision	won	grandtotal	Rate%=won/Grandtota
jan	40	30	3	73	won/Grandtotal(3/73)
feb	45	35	4	84	won/Grandtotal(4/84)
mar	65	45	5	115	won/Grandtotal
grandtotal	150	110	12	272	won/Grandtotal

my using the this expression count({<status={'won'}>}[month])/count(status)

month	lost		nodecision		won		grandtotal	Rate%
	grandtotal	Rate%	grandtotal	Rate%	grandtotal	Rate%
jan	40		30		3		73
feb	45		35		4		84
mar	65		45		5		115
grandtotal	150		110		12		272

it will generate like this but i need only rate% column after the grand total only. is it possible to generate only Rate% after the grandtotal column not required remaining rate%(don't show in pivot table).how

any one plz help me urgent......

[ecolomer]

Is this you need?

[#3]

No,i have only close rate% after the grand total  plz tell me...

[ecolomer]

That?

[raptibhowal]

Hope this might help u....