1<?xml version="1.0" encoding="UTF-8"?>
2
3
4
5<!--
6 ***********************************************************************
7 *
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 *
10 * Copyright 2000, 2011 Oracle and/or its affiliates.
11 *
12 * OpenOffice.org - a multi-platform office productivity suite
13 *
14 * This file is part of OpenOffice.org.
15 *
16 * OpenOffice.org is free software: you can redistribute it and/or modify
17 * it under the terms of the GNU Lesser General Public License version 3
18 * only, as published by the Free Software Foundation.
19 *
20 * OpenOffice.org is distributed in the hope that it will be useful,
21 * but WITHOUT ANY WARRANTY; without even the implied warranty of
22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
23 * GNU Lesser General Public License version 3 for more details
24 * (a copy is included in the LICENSE file that accompanied this code).
25 *
26 * You should have received a copy of the GNU Lesser General Public License
27 * version 3 along with OpenOffice.org.  If not, see
28 * <http://www.openoffice.org/license.html>
29 * for a copy of the LGPLv3 License.
30 *
31 ************************************************************************
32 -->
33
34
35		<helpdocument version="1.0">
36<meta>
37<topic id="textscalcguidedatapilot_groupingxml" indexer="include" status="PUBLISH">
38<title id="tit" xml-lang="en-US">Grouping Pivot Tables</title>
39<filename>/text/scalc/guide/datapilot_grouping.xhp</filename>
40</topic>
41</meta>
42<body>
43<bookmark xml-lang="en-US" branch="index" id="bm_id4195684"><bookmark_value>grouping; pivot tables</bookmark_value>
44<bookmark_value>pivot table function;grouping table entries</bookmark_value>
45<bookmark_value>ungrouping entries in pivot tables</bookmark_value>
46</bookmark>
47<paragraph role="heading" id="par_idN10643" xml-lang="en-US" level="1" l10n="NEW"><variable id="datapilot_grouping"><link href="text/scalc/guide/datapilot_grouping.xhp">Grouping Pivot Tables</link>
48</variable></paragraph><comment>see http://specs.openoffice.org/calc/compatibility/grouping.sxw</comment><paragraph role="paragraph" id="par_idN10661" xml-lang="en-US" l10n="NEW">The resulting pivot table can contain many different entries. By grouping the entries, you can improve the visible result.</paragraph>
49<list type="ordered">
50<listitem>
51<paragraph role="paragraph" id="par_idN10667" xml-lang="en-US" l10n="NEW">Select a cell or range of cells in the pivot table.</paragraph>
52</listitem>
53<listitem>
54<paragraph role="paragraph" id="par_idN1066B" xml-lang="en-US" l10n="CHG">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph>
55</listitem>
56</list>
57<paragraph role="paragraph" id="par_idN1066E" xml-lang="en-US" l10n="NEW">Depending on the format of the selected cells, either a new group field is added to the pivot table, or you see one of the two <link href="text/scalc/01/12090400.xhp">Grouping</link> dialogs, either for numeric values, or for date values.</paragraph>
58<paragraph role="paragraph" id="par_id3328653" xml-lang="en-US" l10n="NEW">The pivot table must be organized in a way that grouping can be applied.</paragraph>
59<list type="unordered">
60<listitem>
61<paragraph role="paragraph" id="par_idN10682" xml-lang="en-US" l10n="CHG">To remove a grouping, click inside the group, then choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph>
62</listitem>
63</list>
64<section id="relatedtopics">
65<embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
66<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
67<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
68<embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
69<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
70<embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
71</section>
72</body>
73</helpdocument>
74