L
LizaJane
I am needing to take a large data population and create a report based on the
Sales Rep/Customer combination. I need each repset(combination) on a new tab
and then I need to pdf it.
I am including a sample of the layout.
Please help as I need to do this ASAP.
Thanks.
Lisa
Walt Chittum 16 Lost, New and Popular Item Opportunties
Knoxville Zoo Cust # 207915
LOST = Items Purchased Two or More Times in July - Dec 08, But Not In
Jan-May 09
Item # Description July-Dec 2008 Purchases of Item # Events Average Unit
Price Most Recent Purchase Date Most Recent Purchase Unit Price Price
Level System Price Average Unit Price 12 Mos Data
NEW = Items Purchased in 2009, Not in 2008 (See if item lost above has been
replaced)
Item # Description Jan thru May 2009 Purchases of Item #
Events Average Unit Price Most Recent Purchase Date Unit Price
POPULAR = Top 10 Items on Most Popular Item List Not Purchased by
Customer
Item # Description System Price Kelsan Avg Unit Price
Sales Rep/Customer combination. I need each repset(combination) on a new tab
and then I need to pdf it.
I am including a sample of the layout.
Please help as I need to do this ASAP.
Thanks.
Lisa
Walt Chittum 16 Lost, New and Popular Item Opportunties
Knoxville Zoo Cust # 207915
LOST = Items Purchased Two or More Times in July - Dec 08, But Not In
Jan-May 09
Item # Description July-Dec 2008 Purchases of Item # Events Average Unit
Price Most Recent Purchase Date Most Recent Purchase Unit Price Price
Level System Price Average Unit Price 12 Mos Data
NEW = Items Purchased in 2009, Not in 2008 (See if item lost above has been
replaced)
Item # Description Jan thru May 2009 Purchases of Item #
Events Average Unit Price Most Recent Purchase Date Unit Price
POPULAR = Top 10 Items on Most Popular Item List Not Purchased by
Customer
Item # Description System Price Kelsan Avg Unit Price