topic Total amount in a Pivote table in QlikView https://community.qlik.com/t5/QlikView/Total-amount-in-a-Pivote-table/m-p/290907#M1201961 <HTML><HEAD></HEAD><BODY><P>Hi Markus,</P><P>Please provide us the sample data and file to understand your issue</P><P>Rgds</P><P>Sunil</P></BODY></HTML> Mon, 29 Nov 2010 09:11:34 GMT 2010-11-29T09:11:34Z Total amount in a Pivote table https://community.qlik.com/t5/QlikView/Total-amount-in-a-Pivote-table/m-p/290906#M1201958 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a problem with my Pivot table.</P><P>The system doesn´t calculate the total amount. Each line is correct but it doesn´t give me the total.</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2958_sourceID:2958" /></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">The problem is in the last column "nyttjandegrad"</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">=((sum(qty_produced))/((sum(opworked_time)*24)-sum(opworked_time_stopptid)*24))/(resource_efficiency*60)</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">Thanks in advance</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">Markus</P><P></P></BODY></HTML> Mon, 29 Nov 2010 08:51:29 GMT https://community.qlik.com/t5/QlikView/Total-amount-in-a-Pivote-table/m-p/290906#M1201958 2010-11-29T08:51:29Z Total amount in a Pivote table https://community.qlik.com/t5/QlikView/Total-amount-in-a-Pivote-table/m-p/290907#M1201961 <HTML><HEAD></HEAD><BODY><P>Hi Markus,</P><P>Please provide us the sample data and file to understand your issue</P><P>Rgds</P><P>Sunil</P></BODY></HTML> Mon, 29 Nov 2010 09:11:34 GMT https://community.qlik.com/t5/QlikView/Total-amount-in-a-Pivote-table/m-p/290907#M1201961 2010-11-29T09:11:34Z Total amount in a Pivote table https://community.qlik.com/t5/QlikView/Total-amount-in-a-Pivote-table/m-p/290908#M1201963 <HTML><HEAD></HEAD><BODY><P>/Markus</P></BODY></HTML> Mon, 29 Nov 2010 09:26:15 GMT https://community.qlik.com/t5/QlikView/Total-amount-in-a-Pivote-table/m-p/290908#M1201963 2010-11-29T09:26:15Z