SUB TOTAL

[upaliwije]

In my below Pivot Tbale sub total are not shown for all policies Last policy where there is only one entry sub total is shown. Pls help me to correct this

RISK	POLICY_NO	REF_NO	TRAN_TYPE	TRAN_DATE	IF(D_C='D',SUM(AMOUNT))	IF(D_C='C',SUM(AMOUNT))
SPRV2634	AK00121H0000004	AK0015D0014840	DEBIT	03-Nov-15	3,391	-
SPRV2634	AK00121H0000004	AK0016R0045941	SETTLEMENT	07-Jan-16	-	3,391
SPRW8596	AK00151H0000006	AK0016D0016624	DEBIT	01-Jun-16	4,352	-
SPRW8596	AK00151H0000006	AK0016C0002889	CANCELLED	19-Sep-16	-	4,352
SPRW2654	AK00111H000003	AK0016D0017268	DEBIT	12-Aug-16	4,010	-
SPRW2654	Total				4,010	-

[rajpreeths]

Could you please share your application with sample data here ???

[qlikview979]

Hi ,

Can you Pls Share the  Sample app

Regards

Mahesh

[stabben23 · Accepted solution]

Hi, use set Expression instead. sum({<D_C={'D'}>}Amount), sum({<D_C={'C'}>}Amount).

[upaliwije]

TKS IT IS WORKING