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

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1