https://community.qlik.com/t5/QlikView/Total-expression/m-p/1508631#M750522 <P>Hi experts!</P><P>please look at my Qv file, why when I filter a customer the sales% is getting wrong?</P><P>&nbsp;</P> Sat, 16 Nov 2024 05:12:55 GMT Anonymous 2024-11-16T05:12:55Z https://community.qlik.com/t5/QlikView/Total-expression/m-p/1508631#M750522 <P>Hi experts!</P><P>please look at my Qv file, why when I filter a customer the sales% is getting wrong?</P><P>&nbsp;</P> Sat, 16 Nov 2024 05:12:55 GMT https://community.qlik.com/t5/QlikView/Total-expression/m-p/1508631#M750522 Anonymous 2024-11-16T05:12:55Z https://community.qlik.com/t5/QlikView/Total-expression/m-p/1508632#M750523 <P>Try this?</P><P><STRONG>=sum({&lt;type={1}&gt;}SalesAmount)/ sum(TOTAL {&lt;type={1}<FONT color="#FF0000">, Customer</FONT>&gt;}SalesAmount)</STRONG></P> Sun, 18 Nov 2018 14:32:53 GMT https://community.qlik.com/t5/QlikView/Total-expression/m-p/1508632#M750523 Anil_Babu_Samineni 2018-11-18T14:32:53Z