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

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


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=393937