Issue 117289 - DataPilot - Grouping - Subtotals appear twice
Summary: DataPilot - Grouping - Subtotals appear twice
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: DEV300m101
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2011-03-09 07:22 UTC by Oliver Brinzing
Modified: 2014-01-11 17:31 UTC (History)
3 users (show)

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

datapilot_grouping_subtotals (25.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-03-09 07:22 UTC, Oliver Brinzing
no flags Details
datapilot_grouping_subtotals.gif (21.69 KB, image/gif)
2011-03-09 07:23 UTC, Oliver Brinzing
no flags Details
reproduced spreadsheet (26.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-11 17:31 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Oliver Brinzing 2011-03-09 07:22:19 UTC
Created attachment 76052 [details]

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]
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
Comment 7 Edwin Sharp 2014-01-11 17:31:22 UTC
Created attachment 82254 [details]
reproduced spreadsheet