Level of detail calculation

[juesong]

Hi, I am dealing with the below scenario.

Table A: Territory-Level Info

Territory	Month	Territory Revenue	Territory Usage
Territory A	Oct	1000	100

Table B: Account-Level info (multiple accounts under one territory)

Account	Territory	Month	Account Usage
Account A	Territory A	Oct	10
Account B	Territory A	Oct	90

Desired Output: Calculate account-level revenue based on usage

Account	Territory	Month	Account Usage	Account Revenue
Account A	Territory A	Oct	10	100
Account B	Territory A	Oct	90	900

Any guidance would be greatly appreciated!!!

[atcodedog05 · Accepted solution]

Hi @juesong 

Here is a workflow for the task. I am assuming the calculation here as ratio.

Output:

Workflow:

Calculation assumption. Calculating portions of

100 -> 1000

90 -> ?

? = (90/100)*1000

  = 900

Hence formula

([Account Usage]/[Territory Usage])*[Territory Revenue]

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu · Accepted solution]

@juesong 

Something like this?

[atcodedog05]

Hi @juesong 

I have updated my solution with a logical calculation assumption for calculating part of whole. 🙂

[juesong]

Appreciate your help!

[juesong]

Thanks a lot for your help!

[atcodedog05]

Happy to help 🙂 @juesong 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂