The grids are pretty powerful. There is a lot you can do with them.
|Change order of columns||To move a column, simply "left click and hold" on the column header and drag the column to where you want it.|
First click on the "Column Chooser" icon which should be at the top right of the screen. This will then open a pop up screen. There may already be some hidden columns listed her.
To remove a column, drag the column into the pop up screen.
To add a column, drag it from the "Column chooser" to where you want it
|Resize column||In the column heading row, hover your mouse over the right hand side border and the pointer will change to a resize icon. Left click and resize the column.|
|Pin/Fix a column to the left or right||
Right click on the column heading and you will see a few options, one of which is Fix either to the left or the right. Simply click on the one you want and the column will be moved to the left or right and pinned there.
To undo, simply right click and choose Unfix
Sorting and Filtering
|Sort by a single column||
Simply left click on the column heading and the grid will be sorted by that column, e.g A-Z. Click again to sort in the other direction, e.g Z-A.
If you right click on a column heading, you will see extra options.
|Sort by multiple columns||To sort by multiple columns when using mouse and desktop, simply shift and left click on each column in turn. When you next click on a columng heading, the multi column sorting will be cleared.|
Click on the Filter icon in the top row and apply your filtering conditions. Depending on the data, you will be presented with multiple filtering functions, e.g date functions for dates and text options for text.
You can apply filters across multiple columns.
To clear a filter in one column, hover on the filter icon and click on "Select All".
To clear all filters, click on the Clear button top right.
To search the whole grid, use the global search field at the top right of the page.
This search will only search visible columns. Hidden columns are not included in the search.
|Search within a column||To search within a column, use the search field under the Column header.|
Grouping is very powerful and incredibly easy. Simply "left click and hold" and drag a column heading to the text "Drag a column header here to group by that column"at the top left of the table. You can drag multiple columns and you can reorder the column headings in this are to change the order in which the grid is grouped.
To Ungroup, simply drag the column header back down to the grid.