Average vs Total Sum

[javier_florian]

Hi Everyone,

This case may seem a simple question, but it has a trick that I have not been able to correct, I have the sum of percentages and I compare it with a fixed value (blue color) in each record and I have no difference however in total if I have differences.
In excel throws me the same result, divide the second column on the first and throws me the correct value, but to make full (bold) I re-throw the same difference.
What can I do there?

-Regards

[SergeyMak]

Please share a sample in Excel or qvw

[Anonymous]

The third column, where you divide second by first, is correct.

The blue bold ("total") is average of the above blue rows, and it doesn't make sense.  Example, to illustrate the reason:

Sales of apples in May is $10 and oranges is $30.  Share of apples is 25%

Sales on apples in June is $10,000 and oranges is $10,000 too.  Share of apples is 50%.

Can you say that average share of apples in two months is 37.5%?  Obviously not, because the June amounts are much large then in May.  Without any calculations it is clear that it is close to 50% because May values are insignificant comparing to June.

Hope it helps...

[#4]

Agree with Michael!