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]

Try to put Aggr expression in IF statement

[#3]

‌resolved, by creating a calculated demension =aggr(sum ordered - sum delivered ),n po, product) and place the demension after product culom

thank you