I really need help finding this out. The final result I need to provide is:
1) Cost Per Campaign By Sales Region
2) Cost Per Member ID By Sales Region
I have to show a couple of views in a pivot:
Sales Region,Count of unique Member ID,Unique Program Cost$ by Sales Region,Cost$ per unique program
I tried creating a formula in the Excel sheet but it did not work.
I left an example in the "Campaign" tab (shown in yellow). I also provided a list of the unique campaign codes and unique costs in the tab "CAMPAIGN COST- Unique"
Cost Per Campaign By Area
Cost Per Member ID By Area
PLEASE HELP - I HAVE TO DELIVER THIS TOMORROW MORNING!!!! THANKS!!!!