Modify a Table

You can customize an analysis table by clicking the gear icon at the top of the table:

mceclip0__73_.png

You can modify the analysis table in the following ways:

  • Columns – select from a list of columns to hide or show:

    mceclip1__5_.png
  • Sort – sort a row's cell values (Data Column) in ascending or descending order (Order Direction) and replace or remove column order once it has been ordered (Sort Order Columns):

    mceclip2__3_.png
  • Group – organize rows with grouping and sub-grouping (Grouping Column), replace or remove groups ("Groups"), and exclude details rows ("Detail Rows"):

    mceclip3__2_.png
  • Aggregate – this will calculate totals and/or averages. Set an Aggregate Function for specific Data Columns, replace or remove them ("Aggregates"), choose a position for the calculation results ("Layout"), and Hide Function Names:

    mceclip4__2_.png
  • Paging – choose to show all rows or split by paging and designate how many rows to
    show per page:

    mceclip5__2_.png

You can also modify the table on the table itself. Hover over the left side of any column header to reveal the dots:

mceclip6__2_.png

Drag and drop to change the column order. The dots on the right side of the column will change the width of the column. Click the center of any column to reveal more options of how to adjust the column:

mceclip7__2_.png

 

Was this article helpful?
0 out of 0 found this helpful

Still looking for your answer? How Can We Help?