Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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