Thank you Somedra - been traveling, so a little tardy. The total data table is at the top, the inputs to the graph at the bottom. Currently hard coded, but I would like to dynamically change the "Rebate" numbers in the graph input to update the graph ad hoc based on rebate scenarios using the...
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...
Thanks Montrey. I apolgize, but I mischaracterized the data ... copied and pasted. In the marketing data, there is no record for customers who did not receive a call only for those who do. So each customer has a different number of (records of) marketing calls but a record for every month...
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...