chart pivot table top 85% in cumulative value, and other ? Really good challenge ?? or easy ?

[zarmoton]

Hello

Who can help me please ?

in input i have those values:

Lieu	Famille	Code	Montant
Paris	Dupont	A	10
Paris	Dupont	A	20
Paris	Dupont	B	10
Paris	Dupont	C	20
Paris	Dupont	C	10
Paris	Dupont	C	20
Paris	Dupont	D	1
Paris	Dupont	D	2
Paris	Dupont	D	3
Paris	Durand	E	5
Paris	Durand	E	15
Paris	Durand	F	50
Paris	Durand	F	15
Paris	Durand	G	10
Paris	Durand	G	30
Rouen	Zaf	H	10
Rouen	Zaf	I	9
Rouen	Zaf	I	2
Rouen	Zaf	K	20

and i would like to have a pivot table, where i see the value to the top 85% (in cumulative), the rest in one raw "Other"

Keep only less than 85%, if more cumul in Other
Lieu	Famille	Code	Montant	Cumulative	% Cumulative
Paris	Dupont	C	50	50	52%
Paris	Dupont	A	30	80	83%
Paris	Dupont	Other	16	96	100%
	96
Paris	Durand	F	65	65	52%
Paris	Durand	G	40	105	84%
Paris	Durand	Other	20	125	100%
	125
Rouen	Zaf	K	20	20	49%
Rouen	Zaf	I	11	31	76%
Rouen	Zaf	Other	10	41	100%
			41

appreciate any help ?

[sunny_talwar]

For QV11.2, this is not straight forward, you can check here

ABC Analysis in Qlikview