In the previous section you learned how to collapse and expand individual summary records. Sometimes, however, you’ll want to expand or collapse the entire database as a whole. Use the Outline Level commands to do this. If you choose RAW DATA then everything will be visible — the original data, and all summary records. If you choose GRAND TOTAL then only one record will be visible — the grand total summary record. The choices in between will display varying levels of summary detail.
In addition to expanding and collapsing from the Sum tool, you can also expand and collapse by right clicking on a summary record and choosing these commands from the pop-up menu (you can right click on any cell in the line). If you are using a trackpad you can click with two fingers to access the pop-up menu. This is my favorite way to access these operations because you can select the record and expand/collapse all in one spot.
The expand/collapse operations are also available from the menu bar in the Field>Analyze submenu. Note: These operations only appear in the menus if there are actually summary records in the database – if there aren’t any summary records, the expand/collapse items are omitted from the menus.
|10.0||No Change||Carried over from Panorama 6.0|