topic Show Only Total Row In Pivot in QlikView https://community.qlik.com/t5/QlikView/Show-Only-Total-Row-In-Pivot/m-p/752627#M268187 <HTML><HEAD></HEAD><BODY><P>I have a requirement to suppress certain values in one of the dimensions of a pivot table to show only their Total values. For example, in below case, if Dim1 is 'B' then collapse (via Expression preferably) Dim2 and Dim3 to show only one row with subtotals for that section i.e. Dim1=B, Dim2=L1 and L2, Dim3=SL1 and SL2 and SL3.</P><P></P><P>Thanks.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="384"><TBODY><TR><TD height="20" width="64">Dim1</TD><TD width="64">Dim2</TD><TD width="64">Dim3</TD><TD width="64">Exp1</TD><TD width="64">Exp2</TD><TD width="64">Exp3</TD></TR><TR><TD height="20">A</TD><TD>L1</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L1</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L1</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L2</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L2</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L2</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L1</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L1</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L1</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L2</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L2</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L2</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L1</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L1</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L1</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L2</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L2</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L2</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 01 Dec 2014 20:28:53 GMT Anonymous 2014-12-01T20:28:53Z Show Only Total Row In Pivot https://community.qlik.com/t5/QlikView/Show-Only-Total-Row-In-Pivot/m-p/752627#M268187 <HTML><HEAD></HEAD><BODY><P>I have a requirement to suppress certain values in one of the dimensions of a pivot table to show only their Total values. For example, in below case, if Dim1 is 'B' then collapse (via Expression preferably) Dim2 and Dim3 to show only one row with subtotals for that section i.e. Dim1=B, Dim2=L1 and L2, Dim3=SL1 and SL2 and SL3.</P><P></P><P>Thanks.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="384"><TBODY><TR><TD height="20" width="64">Dim1</TD><TD width="64">Dim2</TD><TD width="64">Dim3</TD><TD width="64">Exp1</TD><TD width="64">Exp2</TD><TD width="64">Exp3</TD></TR><TR><TD height="20">A</TD><TD>L1</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L1</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L1</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L2</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L2</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">A</TD><TD>L2</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L1</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L1</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L1</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L2</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L2</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">B</TD><TD>L2</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L1</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L1</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L1</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L2</TD><TD>SL1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L2</TD><TD>SL2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">C</TD><TD>L2</TD><TD>SL3</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 01 Dec 2014 20:28:53 GMT https://community.qlik.com/t5/QlikView/Show-Only-Total-Row-In-Pivot/m-p/752627#M268187 Anonymous 2014-12-01T20:28:53Z