Partial sum in Pivot tables

Fri, 29 Jan 2010 11:27:25 GMT

Hi all

I have the following Pivot table and want to have a partial sum on the expressions MTD, øQT-1 and FY by Client_Status.

As the expressions a build with long if-statements the partial sum doesn't work. If I only put in a simple
sum (Attribute) statement for them it works.

Can anybody tell me how to get it working?

Many thanks in advance

Melanie

		MTD	MTD	MTD	MTD	øQT-1	øQT-1	øQT-1	øQT-1	FY	FY	FY	FY
	Staus	C	E	N	Total	C	E	N	Total	C	E	N	Total
Ident	FlowSize				Total				Total				Total
AWFH	groesser5	-	7,865	2,537	-	-	3,703	426	-	-	54,166	10,319	10,319
AWFH	kleiner5	-1,935	-12,710	-	-	-227	-4,679	-	-	-5,704	-78,199	-	-
AWFH	plusminus5	-2,012	-5,538	1,206	-	-482	-1,625	284	-	-8,387	-31,831	6,158	6,158
POUJ	groesser5	-	0	-	0	-	0	-	0	-	34	-	34
POUJ	kleiner5	-	-40	-	-40	-	-2	-	-2	-	-70	-	-70
POUJ	plusminus5	-	0	-	-	-	0	-	-	-	-1	-	-
KLJM	groesser5	-	3,370	1,074	-	-	2,663	463	-	-	35,741	5,634	5,634
KLJM	kleiner5	-165	-4,118	0	-	-79	-2,916	0	-	-1,002	-34,363	-26	-26
KLJM	plusminus5	-157	-729	304	-	-92	-280	214	-	-1,070	-3,653	2,819	2,819

topic Partial sum in Pivot tables in QlikView

Partial sum in Pivot tables