Multi-Section Sheets and Multi-Axis Sheets
JustPerform offers advanced sheet capabilities that enable sophisticated data presentation and reporting through multi-section sheets and multi-axis sheets. These features allow you to create complex data structures within a single sheet while maintaining clarity and organization.
Use Cases and Benefits
The combination of multi-section sheets and multi-axis sheets enables powerful reporting scenarios:
- Consolidated Reporting: Present data at different levels of detail within a single sheet
- Complex Analysis: Combine multiple dimensions and metrics in coordinated views
- Flexible Presentation: Adapt the layout to match your specific reporting requirements
- Efficient Organization: Reduce the need for multiple separate sheets by consolidating related information
Multi-Section Sheets
Multi-section sheets allow you to create multiple sections within a single sheet, with each section having a different level of detail. This capability enables you to utilize multiple sets of fields in the same sheet, making it ideal for sophisticated reporting scenarios.
Key Features
- Each section can have varied levels of detail
- Enables more sophisticated and comprehensive reporting
- Functionality extends to both input snippets and report snippets
- Sections can share axes for coordinated data presentation
How to Create Multi-Section Sheets
Follow these steps to enable and configure multi-section sheets:
- Navigate to the Fields pane of Sheet Details.
- Select Allow Multiple Sections.
- Click Add Section to add more sections to the sheet as needed.
- Add or remove fields from each respective section.
- Configure sections to share axes if desired (see Multi-Axis Sheets below).
Multi-Axis Sheets
Multi-axis sheets provide the ability to add multiple row or column axes to your sheet. This is controlled through the Layout Type setting in the Sheet Layout pane.
Layout Types
JustPerform offers different layout types that determine how fields and axes are structured:
| Layout Type | Description |
|---|---|
| Standard | Fields can be arranged in rows, columns, and filters using traditional layout. |
| Shared Row Axis | Allows you to add multiple row axes to the sheet from the same or different sections |
| Shared Column Axis | Allows you to add multiple column axes to the sheet from the same or different sections |
For more information, see Sheet Details: Layout.
How Multi-Axis Sheets Work
The appearance of the sheet layout is determined by the Layout Type selection:
- Standard Layout: Fields can be arranged in rows, columns, and filters in the traditional manner.
- Shared Axis Layouts: When you change the layout type to Shared Row Axis or Shared Column Axis, you can add multiple row or column axes to the sheet.
- Axes can come from the same section or from different sections of the sheet.
- This provides flexibility in how data is organized and presented.
Configuring Layout Type
To configure the layout type for your sheet:
- Open the Sheet Layout pane.
- Select your desired Layout Type from the available options.
- Configure your row and column axes as needed.
Important: Advanced sheet features require careful planning of your data structure. Before enabling multi‑section or multi‑axis configurations, be sure to consider your reporting requirements and the relationships between fields.