Issue 117289

Summary: DataPilot - Grouping - Subtotals appear twice
Product: Calc Reporter: Oliver Brinzing <oliver.brinzing>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues, oliver.brinzing
Version: DEV300m101Keywords: needmoreinfo
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
datapilot_grouping_subtotals
none
datapilot_grouping_subtotals.gif
none
reproduced spreadsheet none

Description Oliver Brinzing 2011-03-09 07:22:19 UTC 
Created attachment 76052 [details]
datapilot_grouping_subtotals

steps to reproduce

- open attached "datapilot_grouping_subtotals.ods"
- row's "Q1 Sum - Betrag" appears twice - with different cell format
- it does not happen if option "Automatic" is used instead
Comment 1 Oliver Brinzing 2011-03-09 07:23:15 UTC 
Created attachment 76053 [details]
datapilot_grouping_subtotals.gif
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:29:42 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 3 Edwin Sharp 2013-12-18 08:31:01 UTC 
Trying to rebuild Pivot Table - Quartale is missing in source data of attachment 76052 [details].
Comment 4 Edwin Sharp 2014-01-02 09:49:44 UTC 
No info from author.
Comment 5 Oliver Brinzing 2014-01-10 17:22:09 UTC 
steps to reproduce:

- open attached "datapilot_grouping_subtotals.ods"
- delete data pilot
- create new data pilot
  add row fields: Datum
  add column fields: Artikel, Ort
  add data fields: Betrag
  double click on data field "Sum - Betrag" and select "Sum" and "Count"
  (use "ctrl + mouse click" for multiple selection)
- press [ok] to create data pilot
- select first date in data pilot table: 01.01.11
  (question: why is date format different from source data?)
- press F12 for grouping dialog
- group for Months, Quarters and Years
- open data pilot dialog
- double click on row field "Quarters" and select User-definded -> Sum
  (see attached datapilot_grouping_subtotals)
Comment 6 Edwin Sharp 2014-01-11 17:30:15 UTC 
Thank you.

Confirmed with
AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian
Comment 7 Edwin Sharp 2014-01-11 17:31:22 UTC 
Created attachment 82254 [details]
reproduced spreadsheet