0 Replies Latest reply: Mar 8, 2018 5:49 AM by Yeo Poh sai RSS

    How to combine my G1 to G4 sales into one ?

    Yeo Poh sai


      Hi All


      Due to now my sales team G1 to G4 are combine into one group.


      Before the G1 to G4 combine , Below is the table 1 :-


      GROUP_CLASS....sum(sales)

      99..............8800

      G1 ...........5,009,844

      G2 ...........6,060,906

      G3 ...........7,030,611

      G4 ...........4,214,878

      G5 ...........2,863,171

      G6 ...........217,116

      G7 ...........1,467,594

      G8 ...........276,725

      G9 ...........4,395,156

      G12 ...........271,674

      G13 ...........381,544



      I like to make the above table 1 to below , notice that G1-G4 sales are combine :-


      GROUP_CLASS....sum(sales)

      99.............8800

      G1-G4..........22316238.89

      G5 ...........2,863,171

      G6 ...........217,116

      G7 ...........1,467,594

      G8 ...........276,725

      G9 ...........4,395,156

      G12 ...........271,674

      G13 ...........381,544


      Can some one advise me how to do it ?


      Paul Yeo