add % column to the pivot table

[#1]

Hi,

Actually  my problem is i have .qvd file 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)

it will generate like this but i need only rate% column after the grand total only

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

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

[ecolomer]

See the file and image

[#3]

sorry I need only the rate%=won/grandtotal only after the grand total column.

please write the script in the discussion form only plz......

[jagan]

Hi,

Create new expression

Rate % = Sum(won) / (Sum(won)+Sum(lost)+sum(nodecision))

Now in Number tab select Fixed to 1 or 2 (depends on your requirement) and select Show in % option.

Hope this helps you.

Regards,

Jagan.

[#5]

how to calculate won, lost, no decision all are the status column data.

[ecolomer]

Here you have the image

[jagan]

Hi,

Attach some sample data and your expected output, without proper info it is difficult to understand and give solution.  If you want to get the count of won, lost, no decision then use count

Won - Count(won)

lost - Count(lost)

NoDecision - Count(Nodecision)

Rate % = Count(won) / (Count(won)+Count(lost)+Count(nodecision))

Hope this helps you.

Regards,

Jagan.