Calculate % variance on previous quarters. Quarter %, etc. pivot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I calculate a % variance from the previous quarterly total and place
the % variance next to that particular quarter?

Column qtr1 % qtr2 % qtr3 % qtr4 % Total$
Row
item1 50 ?? 75 ?? 100 ?? 125 ??

Example: what is the % variance from qtr1 and qtr2? The variance per cent
will go into the column format betwenn qtr1 and qtr2. Designated as ??.
 
The best way to calculate qtr over qtr performance is the following.

X = Previous Qtr Revenue
Y = New Quarters Revenue

The formula is:

=(Y-X)\X

So in your example for Q1 to Q2 revenue would be:

=(75-50)/50 = 50%

So the increase Qtr over Qtr was 50% You always devide (the difference
from the new quarter to the old quarter) from the old quarter becuase
that is the % you are looking for the delta from.

HTH,

PZan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top