The analysis grid VG style will initially start with every expandable row collapsed. When you click on the (+) next to the value, it will expand that section of the analysis grid and display the data inside. You can have multiple levels nested inside each container and the system will automatically calculate the totals for numeric fields inside the non-visual-grouped fields.
Below is an example of a 3-level
The white area contains all the columns that were not checked as "VG" in the report designer. Here, the columns were the count of the clients for that visual group, how many total clients are on the company, and the client name of each item. You can modify the behavior of the VG aggregate functions on the Advanced box of the fields tab by changing the subtotal function.
Note: Analysis Grid has some requirements.
- You must have at least two fields selected as Visual Groups - Analysis Grid constructs a hierarchy, and you cannot have a hierarchy of one.
- You must have at least one field selected as an aggregate. Once a hierarchy has been built, the grid must have something to display.
- Best practice is for all of the visually grouped fields to be placed at the top of the field order stack.