Group sets of results by one or more columns with Group By, then perform mathematical computations against the columns. Once you define the Group By, switch between the group by and report views using the View Icon on the Search bar.
Parent topic: Customizing an Interactive Report Using the Actions Menu
Use the Group By function in the Actions menu to reorganize an interactive grid.
To use Group By:
A Group By icon appears to the left of the Actions menu. The resulting report displays the Project, Task Name, and Budget columns. Additionally, a new column, Total Cost, displays on the right side.
Parent topic: Grouping Columns
Edit the properties of a grouping in the Goup By dialog.
To edit a group by:
Parent topic: Grouping Columns
Specify group by column sort order (ascending or descending) by either clicking on the group by column heading or selecting Group By Sort on the Data submenu.
You can also specify how to handle NULL values. Using the default setting always displays NULL values last or always displays them first.
To sort a group by column:
See Also:
Creating a Group ByParent topic: Grouping Columns
Delete a grouping in the Group By dialog.
To delete a group by:
Tip:
You can also click the Remove Group By icon to the right of the Edit Group By filter.
Parent topic: Grouping Columns