Reason for Using Cell Level Calculation Description
Screenshot shows a 4 by 4 table. The rows contain Cola, Root Beer, Grape, and a Sum row that adds the other three. Columns contain January, February, Variance, and Percent Variance. Data is as follows:
-
Cola: January, 100. February, 105. Variance, 5. % Var, 5%
-
Root Beer: January, 200. February, 203, Variance, 3. % Var, 3%
-
Grape: January, 50. February, 48. Variance, -2. % Var, -4%
-
Sum: January, 350. February, 356. Variance, 6. % Var, 1.71%