https://community.qlik.com/t5/QlikView/Pivot-table-Sum-by-customer/m-p/1780135#M717490 <P>Hi,</P><P>i have a pivot table where i have several rows for a customer like</P><P>Customer&nbsp; ,&nbsp; Line , Sales</P><P>A,1, 100</P><P>A,2,400</P><P>A,3,500</P><P><SPAN>B,4,100</SPAN></P><P>B,5,100</P><P>&nbsp;</P><P>How can i calculate total by customer on the pivot that is repeated for each row ? like follow</P><P>Customer&nbsp; ,&nbsp; Line , Sales, total</P><P>A,1, 100, 1000</P><P>A,2,400, 1000</P><P>A,3,500, 1000</P><P><SPAN>B,4,100, 200</SPAN></P><P>B,5,100, 200</P><P>&nbsp;</P><P>Thank you</P> Thu, 04 Feb 2021 11:47:36 GMT qlikviewaf 2021-02-04T11:47:36Z https://community.qlik.com/t5/QlikView/Pivot-table-Sum-by-customer/m-p/1780135#M717490 <P>Hi,</P><P>i have a pivot table where i have several rows for a customer like</P><P>Customer&nbsp; ,&nbsp; Line , Sales</P><P>A,1, 100</P><P>A,2,400</P><P>A,3,500</P><P><SPAN>B,4,100</SPAN></P><P>B,5,100</P><P>&nbsp;</P><P>How can i calculate total by customer on the pivot that is repeated for each row ? like follow</P><P>Customer&nbsp; ,&nbsp; Line , Sales, total</P><P>A,1, 100, 1000</P><P>A,2,400, 1000</P><P>A,3,500, 1000</P><P><SPAN>B,4,100, 200</SPAN></P><P>B,5,100, 200</P><P>&nbsp;</P><P>Thank you</P> Thu, 04 Feb 2021 11:47:36 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Sum-by-customer/m-p/1780135#M717490 qlikviewaf 2021-02-04T11:47:36Z https://community.qlik.com/t5/QlikView/Pivot-table-Sum-by-customer/m-p/1780194#M717491 <P>try to create a measure for total as :Sum(<SPAN>Sales</SPAN>)&nbsp; and dimension for&nbsp;<SPAN>customer&nbsp;&nbsp;</SPAN></P> Thu, 04 Feb 2021 13:45:25 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Sum-by-customer/m-p/1780194#M717491 melghandour89 2021-02-04T13:45:25Z