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 ??.