How can I add a variance calculation in a pivot table when the column have two level? (Please refer to the attached excel file for sample) The year data is dynamic and not fixed. I can get the total using the partial sum on the quarter, but not the variance.
