Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional sum on cell values

Good Morning to all,

I have a pivot table like this

LoadingDischargePodOriginaleQ.tàQuan.+Q.Tot????
ABIDJANANVERSAANVERSA3073721
ABU DHABIABIDJANABIDJAN011
ALEXANDRIAABIDJANABIDJAN02020

Now I need to have an additional column ('????') where the result must be the Sum of all the where "Discharge" is equal to the corrisponding "Loading" Port.

Referring to the example, I need, for the first row, an additional column where, I have the sum of the Abidjan of the second row.

In this simply case: 21

Is it possible?

Could anyone help me?

Thanks in advance

0 Replies