blob: 4d845d14cc0eb530d76b5f6c62af3e707f7ba0b8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2000, 2010 Oracle and/or its affiliates.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112080700xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Show Details (DataPilot)</title>
<filename>/text/scalc/01/12080700.xhp</filename>
</topic>
</meta>
<body>
<section id="details">
<paragraph role="heading" id="hd_id3344523" xml-lang="en-US" level="1" l10n="NEW"><link href="text/scalc/01/12080700.xhp">Show Details (DataPilot)</link></paragraph>
<paragraph role="paragraph" id="par_id871303" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Inserts a new "drill-down" sheet with more information about the current DataPilot cell. You can also double-click a DataPilot cell to insert the "drill-down" sheet. The new sheet shows a subset of rows from the original data source that constitutes the result data displayed in the current cell.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dngdrill"/>
</section><comment>see http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_drill-down_on_data_field</comment><comment>For instance, when the data field function is selected to be SUM, then the number that is shown in the data field cell must be identical to the sum of all the data field values in the constituent rows displayed in the inserted sheet.
UFI: this text from spec doc looks like a remark to the developer who implements this feature rather than something for the user</comment><paragraph role="note" id="par_id7132480" xml-lang="en-US" l10n="NEW">Hidden items are not evaluated, the rows for the hidden items are included. Show Details is available only for DataPilot tables that are based on cell ranges or database data.</paragraph>
</body>
</helpdocument>
|
