From 61173c1b58efa79c0ba6b08348d2796a249d0186 Mon Sep 17 00:00:00 2001 From: Norbert Thiebaud Date: Sat, 1 Sep 2012 09:51:27 -0500 Subject: move help structure one directory up Change-Id: Ie970e39fbb6795a92d9fdd13510409d7dcd071bc --- source/text/scalc/01/12050100.xhp | 85 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 85 insertions(+) create mode 100644 source/text/scalc/01/12050100.xhp (limited to 'source/text/scalc/01/12050100.xhp') diff --git a/source/text/scalc/01/12050100.xhp b/source/text/scalc/01/12050100.xhp new file mode 100644 index 0000000000..d578b30d58 --- /dev/null +++ b/source/text/scalc/01/12050100.xhp @@ -0,0 +1,85 @@ + + + + + + + + +1st, 2nd, 3rd Group +/text/scalc/01/12050100.xhp + + +Sun Microsystems, Inc. +converted from old format - fpe + + + +
+ + + +1st, 2nd, 3rd Group +Specify the settings for up to three subtotal groups. Each tab has the same layout. +
+
+ +
+To insert subtotal values into a table: + + +Ensure that the columns of the table have labels. + + +Select the table or the area in the table that you want to calculate subtotals for, and then choose Data – Subtotals. + + +In the Group By box, select the column that you want to add the subtotals to. + + +In the Calculate subtotals for box, select the check boxes for the columns containing the values that you want to subtotal. + + +In the Use function box, select the function that you want to use to calculate the subtotals. + + +Click OK. + + + +Group by +Select the column that you want to control the subtotal calculation process. If the contents of the selected column change, the subtotals are automatically recalculated. + + +Calculate subtotals for +Select the column(s) containing the values that you want to subtotal. + +Use function +Select the mathematical function that you want to use to calculate the subtotals. + + -- cgit