Partial sums pivot table

Tue, 25 Jun 2013 15:51:01 GMT

Hello everyone,

I have a pivot table like this showing people going from one telco operator to another one.

RECEIVERS/GIVERS	ORANGE	VODAFONE	SFR	Totals outgoing
ORANGE	-	5	3	8
VODAFONE	2	-	4	6
SFR	5	6	-	11
Totals incoming	7	11	7	25

When I have the same operator, I have a '-' in my table which is normal but i would like to show instead of the ' - ', the balance : Incoming - Outgoing.

I would like to have this :

RECEIVERS/GIVERS	ORANGE	VODAFONE	SFR	Totals outgoing
ORANGE	- 1	5	3	8
VODAFONE	2	5	4	6
SFR	5	6	-4	11
Totals incoming	7	11	7	25

How can I do that please ?

For information, in my database I have something like this :

ID	RECEIVERS	GIVERS
1	ORANGE	SFR
2	ORANGE	VODAPHONE
3	VODAFONE	SFR

Thanks for you help

topic Partial sums pivot table in QlikView

Partial sums pivot table