Issue 117289 - DataPilot - Grouping - Subtotals appear twice
Summary: DataPilot - Grouping - Subtotals appear twice
Status: CONFIRMED
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:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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]
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