Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Drill (show details)

With a drill you can show for the single, compressed values in the DataPilot result the related detailed data. You can activate a drill through a double-click on the cell or use Data > Group and Outline > Show Details. You have to distinguish two cases:

  1. The active cell is the category of a row or column field.
    In this case drill means an additional breakdown into the categories of another field.
    For example, double-click on the cell with the value golfing in the row field region. In this case the values that are aggregated in the category golfing are subdivided according to another field.
    Since there are more possibilities for a subdivision, a dialog appears where you can make your needed settings.
  2. Before the drill down for the category golfing
    Selection of the field for the subdivision
    After the drill down

    To hide the details again, double-click on the cell golfing or choose Data > Group and Outline > Hide Details.

    The DataPilot remembers your selection (in our example the field employee), so that for the next drill down for a category in the field region the dialog does not appear. To remove the selection employee, open the DataPilot dialog by right-clicking and choosing Start, then delete the unwanted selection in the row or column field.

  3. The active cell is a value of the data field.
    In this case drilldown means a listing of all data entries of the data source that aggregates to this value.
    Double-click on the cell with the value $18,741 and you'll get a list of all data sets that are included in this value. This list is shown in an new sheet.
  4. New table sheet after the drilldown for a value in a data field.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire