Discussion Board for collaboration related to QlikView App Development.
Good Morning to all,
I have a pivot table like this
Loading | Discharge | PodOriginale | Q.tà | Quan.+ | Q.Tot | ???? | |
ABIDJAN | ANVERSA | ANVERSA | 30 | 7 | 37 | 21 | |
ABU DHABI | ABIDJAN | ABIDJAN | 0 | 1 | 1 | ||
ALEXANDRIA | ABIDJAN | ABIDJAN | 0 | 20 | 20 |
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