% column problem in pivot table

Wed, 17 Sep 2014 02:57:02 GMT

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......

Re: % column problem in pivot table

ecolomer — Wed, 17 Sep 2014 03:57:02 GMT

Is this you need?

Re: % column problem in pivot table

Wed, 17 Sep 2014 05:07:06 GMT

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

Re: % column problem in pivot table

ecolomer — Wed, 17 Sep 2014 05:12:51 GMT

That?

Re: % column problem in pivot table

raptibhowal — Wed, 17 Sep 2014 05:44:57 GMT

Hope this might help u....

topic Re: % column problem in pivot table in QlikView

% column problem in pivot table

Re: % column problem in pivot table

Re: % column problem in pivot table

Re: % column problem in pivot table

Re: % column problem in pivot table