Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

below() function in Pivot table and Partial sum

Hi

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 GroupProductDateStockPrevious Day stockDifference in Stock
AP110/28/20136219012845466264
AP110/29/2013128454--
AP1Total190644--
AP210/28/2013107870238628130758
AP210/29/2013238628
AP2Total346498--
AP310/28/2013108098243526135428
AP310/29/2013243526--
AP3Total351624--
ATotal1857116--
BPC110/28/201335029436357413280
BPC110/29/2013363574--
BPC1Total713868--
BPc210/28/201335067436428413610
BPc210/29/2013364284--
BPc2Total714958--
BTotal1428826--
Total3285942--
0 Replies