topic Variance calculation in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Variance-calculation-in-Pivot-table/m-p/180024#M46610 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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.</P></BODY></HTML> Tue, 08 Jun 2010 11:03:43 GMT 2010-06-08T11:03:43Z Variance calculation in Pivot table https://community.qlik.com/t5/QlikView/Variance-calculation-in-Pivot-table/m-p/180024#M46610 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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.</P></BODY></HTML> Tue, 08 Jun 2010 11:03:43 GMT https://community.qlik.com/t5/QlikView/Variance-calculation-in-Pivot-table/m-p/180024#M46610 2010-06-08T11:03:43Z