| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Drillthrough"
(Added hyperlinks) |
(Added the New Sheet button) |
||
| Line 8: | Line 8: | ||
* The '''Destination''' field determines where the Drillthrough information will be placed on the worksheet. | * The '''Destination''' field determines where the Drillthrough information will be placed on the worksheet. | ||
| − | * The '''Limit | + | * The '''Limit rows''' field allows you to restrict the returned result set. |
| + | * You can create a new worksheet to place the data on by clicking on the '''New Sheet''' button and entering a name for the worksheet. | ||
The Drillthrough places the returned data directly onto the spreadsheet. The values inserted are values and not formulae. | The Drillthrough places the returned data directly onto the spreadsheet. The values inserted are values and not formulae. | ||
[[Category:OLAP Operations]] | [[Category:OLAP Operations]] | ||
Revision as of 16:18, 14 October 2010
Drillthrough is used to list the base data from the database that constitutes the cell on the spreadsheet.
The Drillthrough option is available on the right mouse button pop-up menu when:
- the currently active cell contains an XL3Lookup formula
- the currently active cell is part of the data area of an active Grid Reporting Overview
To display the Drill Through dialog, select a cell and choose XLCubed > Drillthrough... from the right mouse button menu.
- The Destination field determines where the Drillthrough information will be placed on the worksheet.
- The Limit rows field allows you to restrict the returned result set.
- You can create a new worksheet to place the data on by clicking on the New Sheet button and entering a name for the worksheet.
The Drillthrough places the returned data directly onto the spreadsheet. The values inserted are values and not formulae.
