5 Replies Latest reply on Dec 14, 2017 2:04 PM by Abby Murphy

# Calculate same average when sub-category dimensions are not within view

I've read different articles on "at level" calculations and other methodology, but I can't seem to figure out what I need... Here is the examples.  I want the subtotal average to be the same number as when the sub-category is listed out.

I want the below numbers to equal the above averages.

• ###### 1. Re: Calculate same average when sub-category dimensions are not within view

See attached

• ###### 2. Re: Calculate same average when sub-category dimensions are not within view

Hi Abby,

It would be great if you could upload some sample data.

The half of the equation that I can figure out is along these lines

{fixed [SRC_rende?] : sum([SRC Servi?]}

HTH

Peter

• ###### 3. Re: Calculate same average when sub-category dimensions are not within view

Sorry about that.  Here is a little more detail that will help.  LOT is the date difference between the min date and max date. So 11 = 11 months.

• ###### 4. Re: Calculate same average when sub-category dimensions are not within view

I'm unable to tell the difference in the other sheet where you get them to roll up the correct way.  I'm sure it's obvious, but I'm missing it somewhere.

• ###### 5. Re: Calculate same average when sub-category dimensions are not within view

Deepak,

Could you explain what the difference in mechanics was between the two tabs?  It appears to work correctly, but I couldn't figure out how to replicate.  Thank you.