topic Re: wrong total sums in chart in QlikView https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435859#M162586 <HTML><HEAD></HEAD><BODY><P>I read this already....the problem is that we have a dynamic chart. we are using conditions for the dimensions! and in total I think we have 20 dimensions</P></BODY></HTML> Thu, 15 Nov 2012 12:04:13 GMT 2012-11-15T12:04:13Z wrong total sums in chart https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435857#M162584 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i have a chart and one expressions looks like this: avg(Versand_Dat.VERSADAT) - min(Artikelstamm.WE) for eacht row in the chart the result is right but the total sum in the pivot table is incorrect. I kind of understand why but I don't know how to solve it? I posted a screenshort as an example. in the screenshot you can see that the total sum is incorrect it should be the average of all the other values</P><P></P><P>can someone help me?</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Thu, 15 Nov 2012 11:56:27 GMT https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435857#M162584 2012-11-15T11:56:27Z Re: wrong total sums in chart https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435858#M162585 <HTML><HEAD></HEAD><BODY><P>A pivot table will always use expression total as total mode. You might want to look into the HELP, sum-of-rows in pivot tables using advanced aggregation.</P><P></P><P>Something like</P><P>=sum( aggr( avg(Versand_Dat.VERSADAT) - min(Artikelstamm.WE), DIM1, DIM2, DIM3))</P></BODY></HTML> Thu, 15 Nov 2012 12:01:33 GMT https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435858#M162585 swuehl 2012-11-15T12:01:33Z Re: wrong total sums in chart https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435859#M162586 <HTML><HEAD></HEAD><BODY><P>I read this already....the problem is that we have a dynamic chart. we are using conditions for the dimensions! and in total I think we have 20 dimensions</P></BODY></HTML> Thu, 15 Nov 2012 12:04:13 GMT https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435859#M162586 2012-11-15T12:04:13Z Re: wrong total sums in chart https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435860#M162587 <HTML><HEAD></HEAD><BODY><P>how can I do this in a dynamic chart???</P></BODY></HTML> Thu, 15 Nov 2012 12:10:40 GMT https://community.qlik.com/t5/QlikView/wrong-total-sums-in-chart/m-p/435860#M162587 2012-11-15T12:10:40Z