Issue 16761 - If both SUM and COUNT, no Grand Total on COUNT
Summary: If both SUM and COUNT, no Grand Total on COUNT
Status: CLOSED DUPLICATE of issue 19290
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 605
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2003-07-13 02:41 UTC by philmperry
Modified: 2010-11-10 16:48 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description philmperry 2003-07-13 02:41:41 UTC
Set up a database with at least 3 columns. In Data>Subtotals define group 1 to
be the SUM of a column, while group 2 is the COUNT of the column. Both groups
are on the same field. In addition to the group SUMs and COUNTs, you get a SUM
Grand Total, but the COUNT Grand Total is missing. Supposedly Excel supplies one.
Comment 1 philmperry 2003-07-13 02:45:34 UTC
Something that may be related: add a 3rd group (still grouped on same
field as groups 1 and 2) and ask for Average. Excel will produce an
average (mean) for each grouping, but no "Grand Total" average of all
the data.
Comment 2 utomo99 2003-09-20 04:37:35 UTC
Please Attach the documents which make this problem, so we can test
it.  (Without the documents, we cannot confirm the problem easily)
Don't forget to cut other part of the documents, so the file size is
small, but we still able to see the problem. 
Comment 3 philmperry 2003-09-21 05:41:48 UTC
This issue was very much like 19290, which has been accepted as an RFE
for OOo 2.0, so closing this one.

*** This issue has been marked as a duplicate of 19290 ***
Comment 4 oc 2004-03-23 17:00:09 UTC
closed because duplicate
Comment 5 inlawcada 2010-11-10 16:48:12 UTC
Created attachment 73293