Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Suggest me how to do that.
Shankar
Sounds to me you should use a Pivot table instead of a Straight table.
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.
Highlighting will probably work when using the Grid Design mode and then right-click the total field to change the layout of that field.