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