Add a summary column

[#1]

Hello everyone,

I created a PivotChart that gives me the numbers of purchase order and products ordered, in column months and under each month the quantities ordered and quantities delivered, how I can add a column that calculates the remainder (sum quan  ordered - sum quantity delivered ) But this column of remaining should not be repeated every month but rather a single column at the end of the table

thank you

Month		janv-16		févr-16		remaining
N° PO	Product	quantity ordered	quantity delivered	Quantity ordered	quantity delivered
1	A	200	100	200	0	300
2	B	200	50	0	50	100
3	A	200	50	200	50	300
3	B	200	0	0	50	150

Ce message a été modifié par : Zoubir Bouchenafa

[bgerchikov · Accepted solution]

Try Calculated Dimension:

It will give one single coulmn.

=Aggr(rangesum(sum (Amount ordered) , - sum(quantity delivered),Produit,MonthYear)

[#3]

‌=Aggr(rangesum(Sum(quantits ordered)-Sum(quantity delivered),Producit,Month)).  It always gives me Error in expression

tthank you for your help

[bgerchikov]

Check syntaxis:

=Aggr(rangesum(

(quantits ordered)

,

-1*(quantity delivered)

)

,Producit,Month)

[#5]

‌it calculates but for each month

[bgerchikov]

Try to add if condition and / or disregard nulls in the chart

[#7]

‌I'm still beginner on Qlikview , can you explain more plz

[bgerchikov]

Check this box in Dimension Tab

[#9]

‌but value is not null so it will not be supressed

[volakakis]

Maybe try another approach since your data is in columns not in rows . Try a cross table? (sorry myself am a newbie but my instructor said that the best way is to keep data in rows not columns)