topic Placing the Total Row within the Table. in QlikView https://community.qlik.com/t5/QlikView/Placing-the-Total-Row-within-the-Table/m-p/159220#M33953 <HTML><HEAD></HEAD><BODY><P>In my straight table i see the option of having the Total Row in the Top or Bottom of the Chart, but is there a way to include it in the sorting so that I could quickly see which customers are above or below the average line?</P><P>i e</P><P>Cust A $4</P><P>Cust C $3</P><P><STRONG>AVERAGE $2.50</STRONG></P><P>Cust B $2</P><P>CustD $1</P></BODY></HTML> Fri, 20 Nov 2009 03:20:29 GMT 2009-11-20T03:20:29Z Placing the Total Row within the Table. https://community.qlik.com/t5/QlikView/Placing-the-Total-Row-within-the-Table/m-p/159220#M33953 <HTML><HEAD></HEAD><BODY><P>In my straight table i see the option of having the Total Row in the Top or Bottom of the Chart, but is there a way to include it in the sorting so that I could quickly see which customers are above or below the average line?</P><P>i e</P><P>Cust A $4</P><P>Cust C $3</P><P><STRONG>AVERAGE $2.50</STRONG></P><P>Cust B $2</P><P>CustD $1</P></BODY></HTML> Fri, 20 Nov 2009 03:20:29 GMT https://community.qlik.com/t5/QlikView/Placing-the-Total-Row-within-the-Table/m-p/159220#M33953 2009-11-20T03:20:29Z Placing the Total Row within the Table. https://community.qlik.com/t5/QlikView/Placing-the-Total-Row-within-the-Table/m-p/159221#M33954 <HTML><HEAD></HEAD><BODY><P>Do not think that this is possible, but you may colour the customers above or below average.</P><P>Peter</P></BODY></HTML> Fri, 20 Nov 2009 03:40:06 GMT https://community.qlik.com/t5/QlikView/Placing-the-Total-Row-within-the-Table/m-p/159221#M33954 prieper 2009-11-20T03:40:06Z Placing the Total Row within the Table. https://community.qlik.com/t5/QlikView/Placing-the-Total-Row-within-the-Table/m-p/159222#M33955 <HTML><HEAD></HEAD><BODY><P>Might it be possible to use a Sort on the amount? You do need Average to be a field within the table (a customer). Probably have to do that while loading the table.</P></BODY></HTML> Fri, 20 Nov 2009 04:39:52 GMT https://community.qlik.com/t5/QlikView/Placing-the-Total-Row-within-the-Table/m-p/159222#M33955 2009-11-20T04:39:52Z