topic Average Partial Sum Column in QlikView https://community.qlik.com/t5/QlikView/Average-Partial-Sum-Column/m-p/197921#M57406 <HTML><HEAD></HEAD><BODY><P>I have a pivot table by REseller (rows) then columns for quarter sub divided by division</P><P>I set a partial sum for the quarters but I want this to average the 4 qtrs within each division, not sum. How do I do this?</P></BODY></HTML> Tue, 30 Mar 2010 21:56:48 GMT 2010-03-30T21:56:48Z Average Partial Sum Column https://community.qlik.com/t5/QlikView/Average-Partial-Sum-Column/m-p/197921#M57406 <HTML><HEAD></HEAD><BODY><P>I have a pivot table by REseller (rows) then columns for quarter sub divided by division</P><P>I set a partial sum for the quarters but I want this to average the 4 qtrs within each division, not sum. How do I do this?</P></BODY></HTML> Tue, 30 Mar 2010 21:56:48 GMT https://community.qlik.com/t5/QlikView/Average-Partial-Sum-Column/m-p/197921#M57406 2010-03-30T21:56:48Z Average Partial Sum Column https://community.qlik.com/t5/QlikView/Average-Partial-Sum-Column/m-p/197922#M57407 <HTML><HEAD></HEAD><BODY><P>I think by changing your expression to something like this:</P><P style="padding-left:30px;">if(dimensionality()=2,avg(aggr(sum(Quantity),Reseller,Division,Quarter)),sum(Quantity)))</P><P>But it's really hard to get the specifics right without an example to play with.</P></BODY></HTML> Tue, 30 Mar 2010 22:13:50 GMT https://community.qlik.com/t5/QlikView/Average-Partial-Sum-Column/m-p/197922#M57407 johnw 2010-03-30T22:13:50Z