Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ??. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |