I have a data table with DISCOUNT (%) as the rows and SHARE (%) as the column. I would like to automatically lookup various combinations of discount and share to populate a chart. The chart input area only uses three of the possible 20 discount percentages and share multiples of five percentage...
I am trying to glean the impact a monthly marketing campaign has on customer behavior and sales. I have two data sets:
1. Customer Purchases
Column A: Customer ID
Column B: Data (MMM/YYYY)
Column C: Purchase Flag (Y/N)
Column D: Revenue ($)
2. Customer Calls
Column A: Customer ID
Column...