Creating Multiple-Grid Sheets

You can create a multiple-grid sheet by placing ad hoc grids from the same data source or different data sources.

For placing multiple grids from multiple data source connections, you can connect to the required data sources before you start creating multiple grid sheet or even during the process.

To create a multiple-grid sheet:

Open a new sheet.
Ensure that the sheet is blank and does not contain any existing data.
Select a range of cells from any location in the sheet.

You must select a range of cells, instead of only one cell.
From the Smart View Home panel, perform an action:
- Select a cube.
- Select a form, right-click on it, and then select Ad Hoc Analysis.
Select Yes in the prompt asking to change the sheet to support multiple grids.
The ad hoc grid is added in the position of the selected range.
To add another grid from the same data source on the sheet:
1. Select a different range of cells.
2. From the Smart View Home panel, select a cube, or select a form, right-click on it, and then select Ad Hoc Analysis.
  The ad hoc grid is added in the position of the selected range.
To add a grid from another data source on the same sheet:
1. Connect to the other data source, if not already connected. In the Extensions menu, select Smart View for Google Workspace, and then select Connect under Start.
  For more information, see Connecting to Data Sources.
2. Select a range of blank cells.
3. In the Extensions menu, select Smart View for Google Workspace, and then select Active Connections under Start.
4. In the Active Connections dialog, click the Server URL list to view the list of active connections, select the required connection, and click Launch Home.
  The Smart View Home panel opens to display the library contents of the connected data source.
5. From the Smart View Home panel, select a cube, or select a form, right-click on it, and then select Ad Hoc Analysis.
  The ad hoc grid is added in the position of the selected range.