0 Replies Latest reply: Jun 25, 2013 11:51 AM by Sadjad Sileman RSS

    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