topic Grouping in Straight Table. in QlikView https://community.qlik.com/t5/QlikView/Grouping-in-Straight-Table/m-p/188241#M51577 <HTML><HEAD></HEAD><BODY><P>Sounds to me you should use a Pivot table instead of a Straight table.</P><P>A Straight table doesn't display subtotals by default. There are ways around this though. For instance by creating subtotal fields in the column you want them in and using a predefined sorting. This can take some work.</P><P>Highlighting will probably work when using the Grid Design mode and then right-click the total field to change the layout of that field.</P></BODY></HTML> Mon, 22 Mar 2010 10:24:34 GMT 2010-03-22T10:24:34Z Grouping in Straight Table. https://community.qlik.com/t5/QlikView/Grouping-in-Straight-Table/m-p/188240#M51576 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to group the straight table with the column value and display the sub totals for each group and also the grand total with highlighted text.</P><P>Suggest me how to do that.</P><P>Shankar</P><P></P></BODY></HTML> Mon, 22 Mar 2010 10:08:55 GMT https://community.qlik.com/t5/QlikView/Grouping-in-Straight-Table/m-p/188240#M51576 2010-03-22T10:08:55Z Grouping in Straight Table. https://community.qlik.com/t5/QlikView/Grouping-in-Straight-Table/m-p/188241#M51577 <HTML><HEAD></HEAD><BODY><P>Sounds to me you should use a Pivot table instead of a Straight table.</P><P>A Straight table doesn't display subtotals by default. There are ways around this though. For instance by creating subtotal fields in the column you want them in and using a predefined sorting. This can take some work.</P><P>Highlighting will probably work when using the Grid Design mode and then right-click the total field to change the layout of that field.</P></BODY></HTML> Mon, 22 Mar 2010 10:24:34 GMT https://community.qlik.com/t5/QlikView/Grouping-in-Straight-Table/m-p/188241#M51577 2010-03-22T10:24:34Z