topic AVG in Pivot Table when dimension is collapsed in QlikView https://community.qlik.com/t5/QlikView/AVG-in-Pivot-Table-when-dimension-is-collapsed/m-p/340128#M125545 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have this problem: In my pivot table there are 5 dimension (year,quarter,month and other 2 dimentions).</P><P>there are more expressions in my pivot table.</P><P>I want to do a average function instead of subtotals ,on year dimension, when the quarter and month dimentions are collapsed.</P><P></P><P>anyone have any idea?</P><P>Thanks,</P><P>Luigi</P></BODY></HTML> Wed, 06 Jun 2012 13:53:13 GMT Anonymous 2012-06-06T13:53:13Z AVG in Pivot Table when dimension is collapsed https://community.qlik.com/t5/QlikView/AVG-in-Pivot-Table-when-dimension-is-collapsed/m-p/340128#M125545 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have this problem: In my pivot table there are 5 dimension (year,quarter,month and other 2 dimentions).</P><P>there are more expressions in my pivot table.</P><P>I want to do a average function instead of subtotals ,on year dimension, when the quarter and month dimentions are collapsed.</P><P></P><P>anyone have any idea?</P><P>Thanks,</P><P>Luigi</P></BODY></HTML> Wed, 06 Jun 2012 13:53:13 GMT https://community.qlik.com/t5/QlikView/AVG-in-Pivot-Table-when-dimension-is-collapsed/m-p/340128#M125545 Anonymous 2012-06-06T13:53:13Z