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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello there, I really appreciate the help. I need to get this figured out. with regards to the sample data, you are referring to the  "Power BI Mock Data" correct? that is an export of the actual data I am working with. I just deleted unnecessary data and changed some confidential data. What can I do with the data to make it less "messy" for you? happy to 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.