Solved: How to get desired subtotal in pivot table based o... - Qlik Community

nevilledhamsiri · ‎2018-04-28

Hi,

Please let me know what steps to be followed in arriving at subtotal on a given dimension?

As per the data, I need the subtotal based on Branch to be taken but it wont come as expected. Should this always be the dimension considered for subtotal or is it with some other dimension as well? Also in order to omit some wording condition appearing on a sum column, what formula to be used!

Thanks

Neville

kaushiknsolanki · ‎2018-04-29

Hi,

Try to encapsulate your expression in sum function like below.

Sum(IF((VTime-REPORTED_DATE)>151,BALANCE_CF))

This will populate the total.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

kaushiknsolanki · ‎2018-04-29

Hi,

Try to encapsulate your expression in sum function like below.

Sum(IF((VTime-REPORTED_DATE)>151,BALANCE_CF))

This will populate the total.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

nevilledhamsiri · ‎2018-04-29

Hi SOLANKI,

Thanks for your reply. I works. Can you also please suggest me how I may void (condition, reverse, do not reverse) being appeared on the sum row.

Thanks

nevilledhamsiri · ‎2018-04-30

Please suggest me an answer to avoid the condition (REVERSE/DO NOT REVERSE) being appeared on the sum row!

RA00	CLRA00CF17000033	5/29/2017	MR. K.D.S.R. UPASENA	5550000	DO NOT REVESE	5550000.00	5550000.00
	CLRA00CF18000002	2/28/2018	MR W.M.A.P. BANDARA		REVERSE	0.00	0.00
	CLRA00CP17000014	10/12/2017	K.D.N.T.K. UPASENA	0	REVERSE	0.00	0.00
	CLRA00CP18000004	2/13/2018	MR. K.D.S.R. UPASENA		REVERSE	0.00	0.00
	CLRA00CP18000007	3/6/2018	MR. K.D.S.R. UPASENA		REVERSE	0.00	0.00
	CLRA00CP18000009	3/21/2018	MR. K.D.S.R. UPASENA		REVERSE	0.00	0.00
	CLRA00CP18000010	3/22/2018	MR. K.D.S.R. UPASENA		REVERSE	11000.00	0.00
	CLRA00CP18000011	4/20/2018	MR. K.D.S.R. UPASENA		REVERSE	46000.00	0.00
	CLRA00CP18000012	4/24/2018	MR. K.D.S.R. UPASENA		REVERSE	1000.00	0.00
	CLRA00DF18000001	4/6/2018	MR. S.H.P. SOMASIRI		REVERSE	26000.00	0.00
	CLRA00EL18000005	3/17/2018	MR. M. PIYASENA		REVERSE	0.00	0.00
	CLRA00EL18000006	4/4/2018	H.M.U. NILOCHANA		REVERSE	0.00	0.00
	CLRA00HC18000002	2/14/2018	RATNALOKA TOUR INNS LTD		REVERSE	0.00	0.00
	CLRA00HC18000005	4/4/2018	RATNALOKA TOUR INNS LTD		REVERSE	11000.00	0.00
	CLRA00HC18000006	4/6/2018	RATNALOKA TOUR INNS LTD		REVERSE	11000.00	0.00
	CLRA00HC18000007	4/24/2018	RATNALOKA TOUR INNS LTD		REVERSE	1000.00	0.00
	CLRA00PH18000013	4/4/2018	E.W.A.M. AIRANGANI		REVERSE	0.00	0.00
	CLRA00PH18000014	4/4/2018	B.G. CHANDRASINGHA		REVERSE	0.00	0.00
	CLRA00PH18000015	4/6/2018	M.D.N.M. DISSANAYAKA		REVERSE	0.00	0.00
	CLRA00PH18000016	4/23/2018	R.P.B.L. DANAWARDENA		REVERSE	0.00	0.00
	CLRA00SS18000002	3/12/2018	G.H.P. PREMARATNE.		REVERSE	0.00	0.00
	CLRA00TC16000027	8/24/2016	MR. H.G.S. SANJEEWA	2500	REVERSE	2500.00	2500.00
	CLRA00TC18000003	3/17/2018	MR. M.M.J. MALDENIYA		REVERSE	0.00	0.00
	CLRA00TC18000004	4/2/2018	MR. K.D.S.R. UPASENA		REVERSE	21000.00	0.00
	CLRA00TC18000005	4/4/2018	MR. K.D.S.R. UPASENA		REVERSE	66000.00	0.00
	CLRA00TF17000022	4/26/2017	MR. K.D.N.T.K UPASENA	251000	DO NOT REVESE	251000.00	251000.00
	CLRA00TF17000056	9/20/2017	MR. K.D.N.T.K. UPASENA	131000	DO NOT REVESE	131000.00	131000.00
	CLRA00TF17000066	12/1/2017	MR. K.D.N.T.K. UPASENA		REVERSE	81000.00	0.00
	CLRA00TF18000003	1/22/2018	MR. M.K.L. ARIYASENA		REVERSE	101000.00	0.00
	CLRA00TF18000011	3/1/2018	MR. SAM.E. LIYANAGE		REVERSE	11000.00	0.00
	CLRA00TF18000012	3/17/2018	MR. THUSHAN UPASENA		REVERSE	46000.00	0.00
	CLRA00TF18000013	3/20/2018	. THE MANAGER		REVERSE	0.00	0.00
	CLRA00TF18000015	4/19/2018	MR. K.D.S.R. UPASENA		REVERSE	40000.00	0.00
	CLRA00TF18000016	4/19/2018	MR. A.L.C.U. LIYANAGE		REVERSE	15000.00	0.00
	CLRA00TF18000017	4/19/2018	MR M.K.L. ARIYASENA		REVERSE	201000.00	0.00
	CLRA001A17000233	9/11/2017	MR. D.W.W. THENNAKOON	100000	REVERSE	100000.00	100000.00
	CLRA001A17000261	10/24/2017	MRS. M.M.N.P MAUDELLA	0	REVERSE	0.00	0.00
	CLRA001A17000262	10/26/2017	MR. N.A.D.S.A. GUNAWARDENA	400000	DO NOT REVESE	400000.00	400000.00
	CLRA001A17000277	11/6/2017	MR. M.S. PRATHAPARACHCHE	10000	REVERSE	10000.00	10000.00
	CLRA001A17000279	11/6/2017	MR. I.H.U. ERANGA	11100	REVERSE	11100.00	11100.00
	CLRA001A17000288	11/13/2017	REV. K. SUNANDA THERO	67000	REVERSE	67000.00	67000.00
	CLRA001A17000292	11/14/2017	MR. G.M. JANAKA	9700	REVERSE	9700.00	9700.00
	CLRA001A17000295	11/16/2017	MRS. S.N. AMARASEKARA	15000	REVERSE	15000.00	15000.00
	CLRA001A17000302	11/23/2017	MR. M. WIJERATNE	0	REVERSE	0.00	0.00
	CLRA001A17000310	12/5/2017	MRS. K.U.T. DE SILVA		REVERSE	8500.00	0.00
	CLRA001A17000312	12/11/2017	DR. V.P.C.D. VIDANAPATHIRANA		REVERSE	9000.00	0.00
	CLRA001A17000314	12/12/2017	MR. K. RAMACHANDRAN		REVERSE	40000.00	0.00
	CLRA001A17000317	12/18/2017	DRMRS. D.S.S. ARIYAPALA		REVERSE	7000.00	0.00
	CLRA001A17000324	12/21/2017	MR. M.M.C.P. HEMACHANDRA		REVERSE	15000.00	0.00
	CLRA001A17000327	12/22/2017	MR. S.G.U. WEERAWANSHA		REVERSE	9000.00	0.00
	CLRA001A17000328	12/27/2017	MRS. M.S.W. TENNAKOON		REVERSE	35000.00	0.00
	CLRA001A17000329	12/27/2017	MISS. H.W.D.N.P. WETTASINGHE		REVERSE	0.00	0.00
	CLRA001A17000333	12/29/2017	MR. M.C. HATHARASINGHE		REVERSE	9000.00	0.00
	CLRA001A18000003	1/2/2018	MR. I.D.D.L KUMARA		REVERSE	0.00	0.00
	CLRA001A18000005	1/5/2018	MR. J.P. ATHUKORALA		REVERSE	23400.00	0.00
	CLRA001A18000012	1/10/2018	MR. N.T.R. JAYAWEERA		REVERSE	40200.00	0.00
	CLRA001A18000014	1/12/2018	MR. N.T.R. JAYAWEERA		REVERSE	60000.00	0.00
	CLRA001A18000017	1/15/2018	MR. V.T.O. BUDDHIKA		REVERSE	20000.00	0.00
	CLRA001A18000018	1/15/2018	MR. G.M. JANAKA		REVERSE	8300.00	0.00
	CLRA001A18000024	1/25/2018	CEYLINCO GENERAL INSURANCE LTD		REVERSE	4800.00	0.00
	CLRA001A18000028	1/29/2018	MR. M.M.C.P. HEMACHANDRA		REVERSE	7500.00	0.00
	CLRA001A18000029	2/1/2018	MR. N NISSANKA		REVERSE	10000.00	0.00
	CLRA001A18000033	2/5/2018	MR. R.P.R. DANASEKARA		REVERSE	0.00	0.00
	CLRA001A18000036	2/6/2018	MR. G.R.S. ARIYARATHNA		REVERSE	12000.00	0.00
CLRA001A18000037	2/12/2018	MR. K.M.P. KARUNAKALAGE		REVERSE	20000.00	0.00
CLRA001A18000039	2/13/2018	MRS. N.V.M. RENUKA		REVERSE	60000.00	0.00
CLRA001A18000041	2/19/2018	MR. N.T.R. JAYAWEERA		REVERSE	35000.00	0.00
CLRA001A18000048	2/27/2018	MR. N.T.R. JAYAWEERA		REVERSE	19100.00	0.00
CLRA001A18000049	2/27/2018	MR. M.K.L. ARIYASENA		REVERSE	36000.00	0.00
CLRA001A18000051	2/28/2018	MR. M.U. JAYANTHA		REVERSE	200000.00	0.00
CLRA001A18000052	3/2/2018	MR. G.K.W.S.M. DE SILVA		REVERSE	20000.00	0.00
CLRA001A18000054	3/2/2018	MR. R. RAJENDRA KUMAR		REVERSE	7500.00	0.00
CLRA001A18000058	3/12/2018	MR. M.Y.M IRHAM		REVERSE	50000.00	0.00
CLRA001A18000059	3/12/2018	MR. A.B. DHARMAWARDHANA		REVERSE	0.00	0.00
CLRA001A18000060	3/13/2018	MR. D.G.N.D. ARIYAWANSHA		REVERSE	0.00	0.00
CLRA001A18000062	3/14/2018	MRS. W.A.I. FERNANDO		REVERSE	2000.00	0.00
CLRA001A18000063	3/16/2018	MRS. R. LOGESWARAN		REVERSE	17000.00	0.00
CLRA001A18000064	3/17/2018	MS. P.A. PUSHPA KUMARA		REVERSE	0.00	0.00
CLRA001A18000065	3/21/2018	MR. K.S.M. KARUNARATHNA		REVERSE	0.00	0.00
CLRA001A18000066	3/21/2018	MRS. J.J. KODIKARA		REVERSE	0.00	0.00
CLRA001A18000067	3/21/2018	MR. P.R. SIRIPALA		REVERSE	50000.00	0.00
CLRA001A18000069	3/23/2018	MR. G.R.S. ARIYARATHNA		REVERSE	8500.00	0.00
CLRA001A18000070	3/26/2018	MR. I.P.K.S. KUMARA		REVERSE	8000.00	0.00
CLRA001A18000071	3/27/2018	MR. H.M.G. BANDARA		REVERSE	0.00	0.00
CLRA001A18000072	3/29/2018	MR. K.K.V.B. PREMARATHNA.		REVERSE	0.00	0.00
CLRA001A18000073	3/30/2018	MR. G.K.K. PRIYANTHA SARATH SILVA		REVERSE	30000.00	0.00
CLRA001A18000074	3/30/2018	DRMRS. D.S.S. ARIYAPALA		REVERSE	8500.00	0.00
CLRA001A18000075	4/2/2018	MR. G.K.K. PRIYANTHA SARATH SILVA		REVERSE	180000.00	0.00
CLRA001A18000076	4/6/2018	MR. H.U.P. HETTIARACHCHI		REVERSE	10500.00	0.00
CLRA001A18000077	4/6/2018	MR. P.G.G. HARISHCHANDRA		REVERSE	0.00	0.00
CLRA001A18000078	4/7/2018	DRMRS. A.I. KODITHUWAKKU.		REVERSE	7500.00	0.00
CLRA001A18000079	4/10/2018	MR. B.K.P.R.P. ABEYSINGHE		REVERSE	15000.00	0.00
CLRA001A18000080	4/10/2018	MRS. K.U.T. DE SILVA		REVERSE	250000.00	0.00
CLRA001A18000081	4/11/2018	MRS. A.D. ABEYSEKARA		REVERSE	3000.00	0.00
CLRA001A18000082	4/12/2018	MR. J.A.S.P.K. JAYASURIYA		REVERSE	12500.00	0.00
CLRA001A18000083	4/16/2018	MR. T.P. DASANAYAKA		REVERSE	75000.00	0.00
CLRA001A18000084	4/18/2018	MR. A.V.V.R. SANDARUWAN		REVERSE	70000.00	0.00
CLRA001A18000085	4/19/2018	DR MR. L.W.D.K. CHATHURANGA		REVERSE	25000.00	0.00
CLRA001A18000086	4/25/2018	MR. D.P. THIWANKA JANANATH		REVERSE	5500.00	0.00
CLRA001B17000025	9/27/2017	MR. M.A.U. PRADEEP	500000	DO NOT REVESE	500000.00	500000.00
CLRA001B17000031	12/13/2017	MR. D.V.M. WICKRAMARATHNA		REVERSE	100000.00	0.00
CLRA001B18000005	1/16/2018	MR. T.N. WIMALSIRI		REVERSE	20000.00	0.00
CLRA001B18000007	1/27/2018	MR. K.A.R. KODISINGHE.		REVERSE	25000.00	0.00
CLRA001B18000008	2/27/2018	MR. H.A.B.J. HITTHETIYA		REVERSE	15000.00	0.00
CLRA001B18000010	3/9/2018	MR. K.A.R. KODISINGHE.		REVERSE	25000.00	0.00
CLRA001B18000011	3/12/2018	MR. W.K. CHANDRADASA		REVERSE	20000.00	0.00
CLRA001B18000012	3/14/2018	MR. A.V. P PEMADASA		REVERSE	22500.00	0.00
CLRA001B18000014	3/21/2018	MR. W.A.A.L. GUNARATHNA		REVERSE	30000.00	0.00
CLRA001C17000075	6/30/2017	MS. S.S.P.ENGINEERS (PRIVATE) LIMITED.	0	REVERSE	0.00	0.00
CLRA001C17000095	8/11/2017	RE.WO:WOODLAN CAR SALE (PVT)LTD., USER MR.K.D.N.T.	200000	DO NOT REVESE	200000.00	200000.00
CLRA001C17000140	12/5/2017	MR. S.D.A. INDRATHILAKA		REVERSE	20000.00	0.00
CLRA001C17000141	12/8/2017	MR. K.D.S.R. UPASENA		REVERSE	50000.00	0.00
CLRA001C17000142	12/11/2017	MS. WINWOOD TEA ESTATE (PVT) LTD		REVERSE	4000.00	0.00
CLRA001C17000144	12/13/2017	MR. P.K.I.U KUMARASIRI		REVERSE	0.00	0.00
CLRA001C17000145	12/14/2017	MR. U.K.P. GUNATHILAKA		REVERSE	65000.00	0.00
CLRA001C17000146	12/20/2017	MR. K.D.S.R UPASENA		REVERSE	30000.00	0.00
CLRA001C17000148	12/22/2017	MR. K.D.S.R. UPASENA		REVERSE	35000.00	0.00
CLRA001C17000150	12/30/2017	MR. T.G.M.N. ARIYAWANSA		REVERSE	10000.00	0.00
CLRA001C18000001	1/2/2018	MRS. R.E ELISNONA		REVERSE	20000.00	0.00
CLRA001C18000003	1/8/2018	MR. M.N. DE SILVA		REVERSE	25000.00	0.00
CLRA001C18000004	1/8/2018	MR. K.D.S.R UPASENA		REVERSE	30000.00	0.00
CLRA001C18000007	1/22/2018	MR. I.D.I.L. KUMARA		REVERSE	12000.00	0.00
CLRA001C18000008	1/22/2018	MR. K.D.S.R UPASENA		REVERSE	9500.00	0.00
CLRA001C18000009	1/25/2018	MRS. W.S.W.K WANNIARACHCHI		REVERSE	15000.00	0.00
CLRA001C18000010	1/30/2018	MR. H.M.P. PUSHPAKUMARA		REVERSE	6000.00	0.00
CLRA001C18000012	2/2/2018	MS. U.N. MARKETING (PVT) LTD		REVERSE	25000.00	0.00
CLRA001C18000014	2/7/2018	MS. S.S.P.ENGINEERS (PRIVATE) LIMITED.		REVERSE	50000.00	0.00
CLRA001C18000015	2/9/2018	MR. A.L.C.U. LIYANAGE		REVERSE	120000.00	0.00
CLRA001C18000018	2/22/2018	MR. N.R. OPATHA		REVERSE	0.00	0.00
CLRA001C18000019	2/26/2018	MS. WINWOOD TEA ESTATE (PVT) LTD		REVERSE	3500.00	0.00
CLRA001C18000020	2/26/2018	MRS. I. SURANGI		REVERSE	0.00	0.00
CLRA001C18000021	3/10/2018	MR. D. PREMATHILAKA		REVERSE	10000.00	0.00
CLRA001C18000022	3/17/2018	MS. WINWOOD TEA ESTATE (PVT) LTD		REVERSE	100000.00	0.00
CLRA001C18000023	3/20/2018	MR. J.A.S.K. WEERASINGHA		REVERSE	1500.00	0.00
CLRA001C18000024	3/24/2018	MR. N.G.S. NAMALGAMUWA		REVERSE	20600.00	0.00
CLRA001C18000025	3/26/2018	MR. L.H.D SHANTHALAL		REVERSE	30000.00	0.00
CLRA001C18000026	3/28/2018	MR. A.L.C.U. LIYANAGE		REVERSE	12700.00	0.00
CLRA001C18000027	3/29/2018	MR. K.D.N.T.K UPASENA		REVERSE	25000.00	0.00
CLRA001C18000028	3/30/2018	MR. K.N.U. YASAWARDANA		REVERSE	10000.00	0.00
CLRA001C18000029	4/2/2018	MR. K.M.N.N.B. DEHIGASTHENNA		REVERSE	3800.00	0.00
CLRA001C18000030	4/3/2018	S.S.P.ENGINEERS (PRIVATE) LIMITED. .		REVERSE	3500.00	0.00
CLRA001C18000031	4/9/2018	MR. M.K.L. ARIYASENA.		REVERSE	25000.00	0.00
CLRA001C18000032	4/9/2018	MS. WINWOOD TEA ESTATE (PVT) LTD		REVERSE	10000.00	0.00
CLRA001C18000033	4/16/2018	MR. W.D.N.W KUMARA		REVERSE	25000.00	0.00
CLRA001C18000034	4/18/2018	MR. K.D.N.T.K UPASENA		REVERSE	50000.00	0.00
CLRA001D17000069	12/9/2017	MR. S. KANNAN		REVERSE	15000.00	0.00
CLRA001D17000070	12/12/2017	MR. M.S. PRATHAPAARACHCHI		REVERSE	4200.00	0.00
CLRA001D17000071	12/18/2017	MR. M.L.S. WIJERATHNA		REVERSE	0.00	0.00
CLRA001D18000001	1/4/2018	MR. K.A KUMARA		REVERSE	20000.00	0.00
CLRA001D18000002	1/8/2018	MR. B.M.A. NIMAL SHANTHA		REVERSE	10000.00	0.00
CLRA001D18000005	1/18/2018	MRS. A.G.C.D. WEERASINGHE		REVERSE	20000.00	0.00
CLRA001D18000007	1/29/2018	MR. N.A.V GUNASEKARA		REVERSE	0.00	0.00
CLRA001D18000009	2/7/2018	R. RAJAKUMAR...		REVERSE	790000.00	0.00
CLRA001D18000010	2/28/2018	MR. G.P. SHASHI		REVERSE	20000.00	0.00
CLRA001D18000012	3/2/2018	MR. E.W. YASARATHNA		REVERSE	0.00	0.00
CLRA001D18000013	3/6/2018	MRS. A.K.K. ARACHCHI		REVERSE	5000.00	0.00
CLRA001D18000014	3/14/2018	MR. K.M.S. KUMARASINGHE		REVERSE	3200.00	0.00
CLRA001D18000016	4/2/2018	MR. B.M.A. NIMAL SHANTHA		REVERSE	15000.00	0.00
CLRA001D18000017	4/9/2018	MR. M.A.M. ASLAM		REVERSE	120000.00	0.00
CLRA001D18000018	4/10/2018	MR. I.G. PIYARATHNA		REVERSE	30000.00	0.00
CLRA001D18000019	4/16/2018	MR. K. MINALWEERAN		REVERSE	10500.00	0.00
CLRA001D18000020	4/27/2018	MR. M.R. WICKRAMASINGHE		REVERSE	25000.00	0.00
CLRA001F17000013	12/27/2017	MR. M.K. UPALI		REVERSE	15000.00	0.00
CLRA001F18000004	4/2/2018	MR. R.M.Y.G.L.U. RATHNAYAKA		REVERSE	19130.00	0.00
CLRA001F18000005	4/18/2018	MRS. P.L.M. VITHARANA		REVERSE	25000.00	0.00
CLRA001F18000006	4/19/2018	MR. A.L.J. UDAYA KUMARA		REVERSE	13000.00	0.00
CLRA001W18000002	2/19/2018	MR. V.R. RANASINGHE		REVERSE	15000.00	0.00
CLRA001W18000005	3/26/2018	MR. R.A.N.N. MAHINDARATHNA		REVERSE	0.00	0.00
CLRA001W18000006	3/30/2018	MR. E.K. JAYASENA		REVERSE	3700.00	0.00
CLRA001W18000007	4/3/2018	MR. G.V.M. NUWAN		REVERSE	10000.00	0.00
CLRA001W18000008	4/10/2018	MR. T.N. JAGATH KUMARA		REVERSE	8530.00	0.00
CLRA001W18000009	4/16/2018	MR. V.R. RANASINGHE		REVERSE	30000.00	0.00
CLRA001W18000010	4/23/2018	MR. U.L.C. WETTASINGHA		REVERSE	24680.00	0.00
CLRA001W18000011	4/23/2018	MRS. K.R. JAYALATH		REVERSE	0.00	0.00
CLRA001W18000012	4/25/2018	MR. L.A.B.N. KARUNARATHNA		REVERSE	35000.00	0.00
CLRA001X17000129	11/1/2017	MR. M.N. WICKRAMASINGHE	3000	REVERSE	3000.00	3000.00
CLRA001X17000141	12/21/2017	MR. G. PREMAWASANTHA		REVERSE	15000.00	0.00
CLRA001X17000142	12/21/2017	MR. P.M.K.D. DAYARATHNA		REVERSE	0.00	0.00
CLRA001X17000144	12/28/2017	MR. K.F. ABBAS		REVERSE	4000.00	0.00
CLRA001X18000001	1/2/2018	MR. K.S.S. LIYANAGE.		REVERSE	10000.00	0.00
CLRA001X18000003	1/3/2018	MR. W.B. SUNILRATHNA		REVERSE	3550.00	0.00
CLRA001X18000005	1/9/2018	MR. R.A. ASHOKA		REVERSE	0.00	0.00
CLRA001X18000008	1/23/2018	MRS. H.K.P. SHANTHILATHA		REVERSE	40000.00	0.00
CLRA001X18000010	1/23/2018	MR. K.M.C. JAYATHILAKA		REVERSE	0.00	0.00
CLRA001X18000012	1/26/2018	MR. A.A.K.R. AMARASINGHE		REVERSE	10000.00	0.00
CLRA001X18000018	2/6/2018	MR. K. RAMESH KUMARA		REVERSE	15000.00	0.00
CLRA001X18000020	2/13/2018	MR. H.D.B.P. WIJERATHNA		REVERSE	10000.00	0.00
CLRA001X18000021	2/14/2018	MR. U.P.K. WIJERATHNA		REVERSE	0.00	0.00
CLRA001X18000022	2/19/2018	MR. K.W.M. MUNASINGHA		REVERSE	0.00	0.00
CLRA001X18000024	2/23/2018	MR. P.P.I. ABENAYAKA		REVERSE	0.00	0.00
CLRA001X18000025	2/26/2018	MR. H.D. JAYATHILAKA		REVERSE	12380.00	0.00
CLRA001X18000026	2/27/2018	MRS. U.G.S.D CHANDRALAL		REVERSE	15000.00	0.00
CLRA001X18000027	2/27/2018	MR. P.G.U. JAYALATH		REVERSE	0.00	0.00
CLRA001X18000028	2/27/2018	MR. K.W.E. CHATHURANGA		REVERSE	30000.00	0.00
CLRA001X18000030	2/28/2018	MR. H.A.I.S. GUNATHILAKA		REVERSE	0.00	0.00
CLRA001X18000032	3/2/2018	MR. K.M.S. KONARAGE		REVERSE	40000.00	0.00
CLRA001X18000036	3/21/2018	MR. H.J.D.K. GUNARATHNA		REVERSE	19000.00	0.00
CLRA001X18000038	3/26/2018	MR. A.L. KUMARA		REVERSE	60000.00	0.00
CLRA001X18000039	3/28/2018	MR. P.V.L. WEERASINGHE		REVERSE	0.00	0.00
CLRA001X18000040	3/30/2018	MR. M. WASANDAN		REVERSE	20000.00	0.00
CLRA001X18000041	4/2/2018	MR. A.A.G.P.N. BANDARANAYAKA		REVERSE	0.00	0.00
CLRA001X18000042	4/3/2018	MR. H.A.D. HETTIARACHCHI		REVERSE	30000.00	0.00
CLRA001X18000043	4/5/2018	MR. P.A.V.I. MADUSHANKA		REVERSE	0.00	0.00
CLRA001X18000044	4/5/2018	MR. A.B. KULARATHNA		REVERSE	10125.00	0.00
CLRA001X18000045	4/9/2018	MR. H.D.B.P. WIJERATHNA		REVERSE	20000.00	0.00
CLRA001X18000046	4/14/2018	MR. S.K. BALASOORIYA		REVERSE	9600.00	0.00
CLRA001X18000047	4/16/2018	MR. K. JAYARATHNA		REVERSE	20000.00	0.00
CLRA001X18000048	4/17/2018	MR. U.B.G. PREMACHANDRA		REVERSE	15950.00	0.00
CLRA001X18000049	4/18/2018	MR. W.P. NEWTON		REVERSE	17000.00	0.00
CLRA001X18000050	4/20/2018	MR. K.A.T.N. KALATUARACHCHI		REVERSE	20000.00	0.00
CLRA001X18000051	4/20/2018	MR. P. DAYARATHNE		REVERSE	10000.00	0.00
CLRA001X18000052	4/23/2018	MR. M. CHANDRAKUMAR		REVERSE	10300.00	0.00
CLRA003F18000002	2/26/2018	MR. W.P.S. WICKRAMARATHNA		REVERSE	0.00	0.00
CLRA004A18000001	4/16/2018	MR. A.S. J. WALPITA		REVERSE	20000.00	0.00
CLRA004C18000001	4/27/2018	MR. P.N. SAMARANAYAKA		REVERSE	40000.00	0.00
CLRA004F17000036	11/27/2017	MRS. THE CHAIRMAN GURULUWAN GEMUNU SANASA SOCITY	20000	REVERSE	20000.00	20000.00
CLRA004F17000039	12/18/2017	MR. P.C. ELAPATHA		REVERSE	1000.00	0.00
CLRA004F17000040	12/27/2017	MR. S.N. JANAKA SAMPATH		REVERSE	15000.00	0.00
CLRA004F18000002	1/2/2018	MR. J.A.G.C. JAYASINHGE		REVERSE	100000.00	0.00
CLRA004F18000004	1/19/2018	MRS. J.M.S.K. JAYAMANNA		REVERSE	10000.00	0.00
CLRA004F18000006	1/27/2018	MR. S. DEWANARAYANA		REVERSE	30000.00	0.00
CLRA004F18000007	2/28/2018	MR. B. JAYARATHNA		REVERSE	20000.00	0.00
CLRA004F18000008	2/28/2018	MR. P.P.S.S. RAJAPAKSHE		REVERSE	15000.00	0.00
CLRA004F18000009	3/20/2018	MR. K.L.B. SUDHARMA		REVERSE	25000.00	0.00
CLRA004F18000010	3/22/2018	MR. N.L.D. SALINGA CHANDRASIRI		REVERSE	0.00	0.00
CLRA004F18000011	4/2/2018	MR. N.E.S. GUNAWARDANA		REVERSE	12500.00	0.00
CLRA004F18000012	4/17/2018	MR. P.S. PREMAKUMARA		REVERSE	25000.00	0.00
CLRA004F18000013	4/27/2018	MR. T.S. THILAKARATHNA		REVERSE	15000.00	0.00
CLRA004X17000003	1/27/2017	MR. H.N. ATHAPATHTHU	0	REVERSE	0.00	0.00
CLRA004X17000048	11/21/2017	MRS. M.A.A. MAHESHANI	30000	REVERSE	30000.00	30000.00
CLRA004X17000051	12/28/2017	MR. W.L. SIRISENA		REVERSE	15000.00	0.00
CLRA004X18000001	1/9/2018	MR. K.H.S.D. SENARATHNE		REVERSE	10000.00	0.00
CLRA004X18000002	1/25/2018	MR. W.A.L. UDAYAKUMARA		REVERSE	0.00	0.00
CLRA004X18000003	3/12/2018	MR. M.G.H.L. MAYADUNNA		REVERSE	10000.00	0.00
CLRA004X18000004	3/12/2018	MR. M.E.J. PREMAKUMARA		REVERSE	17000.00	0.00
CLRA004X18000005	3/26/2018	MRS. W.M.A.P. KULARATHNA		REVERSE	9100.00	0.00
CLRA004X18000006	4/19/2018	MR. R. RAVICHANDRAN		REVERSE	20000.00	0.00
CLRA004X18000007	4/24/2018	MRS. S.N.N.S. PREMASIRI		REVERSE	10000.00	0.00
CLRA004X18000008	4/25/2018	MR. P.D. PRIYANTHA KUMARA		REVERSE	20000.00	0.00
Total				REVERSE	12841645.00	7300300.00
Total					REVERSE	12841645.00	7300300.00

How to get desired subtotal in pivot table based on a given imension