qlikview rollup

[laxmiprasanna]

Here is the data .

center code	cedent cd	cedent name	geo	cont #	Amt1	Amt2	Am3
X	123	DFGH	CENTRAL	X345-2011	0	-524	300
X	123	DFGH	CENTRAL	X345-2012	12	56	-467
X	123	DFGH	CENTRAL	X345-2013	0	0	534
X	123	DFGH	CENTRAL	X345-2014	6	0	-234
X	123	DFGH	CENTRAL	X345-2015	1	4	23
X	123	DFGH	CENTRAL	X345-2016	0	0	34
X	123	DFGH	CENTRAL	X345-2017	2	0	-45
X	123	DFGH	CENTRAL	X345-2018	0	4	23

And I need to show as mentioned below.

center code	cedent cd	cedent name	geo	Amt1	Amt2	Am3
X	123	DFGH	CENTRAL	21	-460	-400

Data should roll up to cedent level but AMT1,AMT2, AMT3 should be displayed values only when AMT1<>0 OR AMT2<>0

 How to achieve this using set analysis? please provide pointers.

[trdandamudi]

Please see the attached file for the code: