Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Max Count Multiplication

I'm hoping this is an easy solution and I'm just missing it. Here's the deal. I have a set of accounts in a table, each row has data on those accounts with historical spend and has been assigned a ti...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi  Anonymous ,

 

I was abble to drill down your pivot table and get the data for the format you need however I have some questions regarding the calculations based on the PHONE CT AOV, you don't have a match between the values from tier 7 to tier 10?, I see you have direct input to the column K but believe there is an incorrection the values.

 

Can you check the total opportunity formula since currently you have

 

Tier 7 - K10

Tier8 - K9

Tier9 - K10

Tier 10 - K10

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

The first dataset, the "Mock data" is the actual data I need help with. the second one was just an example of what u had done in the past in excel, please disregard.  I NEED HELP. Please look at the mock data and tell me how to sum the counts (maxed at 4000) and multiply against the campaign aov.