below() function in Pivot table and Partial sum

Tue, 12 Nov 2013 20:52:11 GMT

In below mentioned scenario, I am using below () function to copy stock value from previous day on current day under column “previous day stock”. Also calculating difference using below () function in formula and displaying difference in stock (Previous day stock – Stock) under difference column.

Now when we are enabling Show Partial sum at product and Product group level it not displaying total for the column “Previous day stock” and “difference in Stock”

Please someone can help us to display total in the column where below () function is used.

Showing the sample pivot table below for your reference

Product Group	Product	Date	Stock	Previous Day stock	Difference in Stock
A	P1	10/28/2013	62190	128454	66264
A	P1	10/29/2013	128454	-	-
A	P1	Total	190644	-	-
A	P2	10/28/2013	107870	238628	130758
A	P2	10/29/2013	238628
A	P2	Total	346498	-	-
A	P3	10/28/2013	108098	243526	135428
A	P3	10/29/2013	243526	-	-
A	P3	Total	351624	-	-
A	Total		1857116	-	-
B	PC1	10/28/2013	350294	363574	13280
B	PC1	10/29/2013	363574	-	-
B	PC1	Total	713868	-	-
B	Pc2	10/28/2013	350674	364284	13610
B	Pc2	10/29/2013	364284	-	-
B	Pc2	Total	714958	-	-
B	Total		1428826	-	-
Total			3285942	-	-

topic below() function in Pivot table and Partial sum in QlikView

below() function in Pivot table and Partial sum