I am trying to analyse sales by grouping together market sector codes, eg
create a new column by grouping the market sectors.
Unit Price Market New Group
21.95 AERO Sector1
19.44 AERO Sector1
1.1297 AGRI Sector2
1.9399 AGRI Sector2
0.35 AGRI Sector2
2.0601 AGRI Sector2
0.3108 AGRI Sector2
25.69 ANEQ Sector1
57.06 ANEQ Sector1
4.53 ANEQ Sector1
1.5 ANEQ Sector1
12.64 ANEQ Sector1
19.17 ANEQ Sector1
49.03 ANIM Sector2
7.37 ANIM Sector2
49.03 ANIM Sector2
1.93 AUTO Sector1
4.12 AUTO Sector1
88.65 AUTO Sector1
28.49 BUSC Sector2
29.62 BUSC Sector2
70 BUSC Sector2
12.71 CHPH Sector3
5.54 CHPH Sector3
10.82 CHPH Sector3
17.21 CHPH Sector3
81.81 CHPH Sector3
1218.14 CHPH Sector3
1218.14 CHPH Sector3
52.99 CHPH Sector3
43.9 CHPH Sector3
29.51 COMP Sector3
19.61 COMP Sector3
13.33 COMP Sector3
0.009 COMP Sector3
5.47 COMP Sector3
13.33 COMP Sector3
5.47 COMP Sector3
46.88 COMV Sector1
88 COMV Sector1
284.06 COMV Sector1
237.81 COMV Sector1
Can anyone advise which is teh best way to do this or is it easier to try & condition the data using sql before extracting??
Anyones help would be much appreciated
create a new column by grouping the market sectors.
Unit Price Market New Group
21.95 AERO Sector1
19.44 AERO Sector1
1.1297 AGRI Sector2
1.9399 AGRI Sector2
0.35 AGRI Sector2
2.0601 AGRI Sector2
0.3108 AGRI Sector2
25.69 ANEQ Sector1
57.06 ANEQ Sector1
4.53 ANEQ Sector1
1.5 ANEQ Sector1
12.64 ANEQ Sector1
19.17 ANEQ Sector1
49.03 ANIM Sector2
7.37 ANIM Sector2
49.03 ANIM Sector2
1.93 AUTO Sector1
4.12 AUTO Sector1
88.65 AUTO Sector1
28.49 BUSC Sector2
29.62 BUSC Sector2
70 BUSC Sector2
12.71 CHPH Sector3
5.54 CHPH Sector3
10.82 CHPH Sector3
17.21 CHPH Sector3
81.81 CHPH Sector3
1218.14 CHPH Sector3
1218.14 CHPH Sector3
52.99 CHPH Sector3
43.9 CHPH Sector3
29.51 COMP Sector3
19.61 COMP Sector3
13.33 COMP Sector3
0.009 COMP Sector3
5.47 COMP Sector3
13.33 COMP Sector3
5.47 COMP Sector3
46.88 COMV Sector1
88 COMV Sector1
284.06 COMV Sector1
237.81 COMV Sector1
Can anyone advise which is teh best way to do this or is it easier to try & condition the data using sql before extracting??
Anyones help would be much appreciated