Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Partial sums pivot table

Hello everyone,

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

RECEIVERS/GIVERS
ORANGEVODAFONESFRTotals outgoing
ORANGE      -538
VODAFONE2-46
SFR56-11
Totals incoming711725

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
ORANGEVODAFONESFRTotals outgoing
ORANGE     - 1538
VODAFONE2               546
SFR56       -411
Totals incoming711725

How can I do that please ?

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

ID RECEIVERSGIVERS
1ORANGESFR
2ORANGEVODAPHONE
3VODAFONESFR

..

Thanks for you help

0 Replies