G
Guest
Needing help with creating report for comparison of sales data over two
periods.
Existing sample data is as follows:
(DECEMBER 2004)
A1=AGENT CODE
B1=AGENT NAME
C1=BOOKING
D1=SALES
A1:A500 DATA FIELDS
(DECEMBER 2005)
F1=AGENT CODE
G1=AGENT NAME
H1=BOOKING
I1=SALES
F1:I500 DATA FIELDS
What I need is a simple Comparison Table sitting to the right of the two
data feilds
K1=AGENT CODE
L1=AGENT NAME
M1=CHANGE IN BOOKINGS
N1=CHANGE IN SALES
O1=CHANGE IN SALES (PERCENTAGE)
Because of new and cancelled agents, the order that the sales data appears
is all over the place. I need the Comparison table to be able to firstly
match up agent codes (ie K1 & A1). If there is no match for K1, then print
"NEW AGENT" in the N1 fields. If no match up with A1, then print "CANCELLED
AGENT" in the same field. If there is a match up between the two, calculate
fields for M1, N1 and O1.
Hope this makes sense. I'm still very much a novice with this stuff. Any
help is greatly appreciated.
Rgds
GP
periods.
Existing sample data is as follows:
(DECEMBER 2004)
A1=AGENT CODE
B1=AGENT NAME
C1=BOOKING
D1=SALES
A1:A500 DATA FIELDS
(DECEMBER 2005)
F1=AGENT CODE
G1=AGENT NAME
H1=BOOKING
I1=SALES
F1:I500 DATA FIELDS
What I need is a simple Comparison Table sitting to the right of the two
data feilds
K1=AGENT CODE
L1=AGENT NAME
M1=CHANGE IN BOOKINGS
N1=CHANGE IN SALES
O1=CHANGE IN SALES (PERCENTAGE)
Because of new and cancelled agents, the order that the sales data appears
is all over the place. I need the Comparison table to be able to firstly
match up agent codes (ie K1 & A1). If there is no match for K1, then print
"NEW AGENT" in the N1 fields. If no match up with A1, then print "CANCELLED
AGENT" in the same field. If there is a match up between the two, calculate
fields for M1, N1 and O1.
Hope this makes sense. I'm still very much a novice with this stuff. Any
help is greatly appreciated.
Rgds
GP