Issue 118849 - pivot report produces rows instead of columns
Summary: pivot report produces rows instead of columns
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO330m20
Hardware: PC Windows Vista
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-01-29 16:18 UTC by tommyads
Modified: 2012-09-07 03:00 UTC (History)
1 user (show)

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

Attachments
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 tommyads 2012-01-29 16:18:19 UTC 
From the Table
ColA	ColN1	ColN2
Alpha	22	54
Alpha	32	2
Beta	5	33
Gamma	3	43
Gamma	44	66

the data-pilot should generate a report summing up the corresponding numbers for the same values in column ColA, yielding the table

ColA	ColN1	ColN2
Alpha	54	56
Beta	5	33
Gamma	47	109

But, instead of this, it yields the table

ColA	Daten	
Alpha	Summe - ColN1	54
	Summe - ColN2	56
Beta	Summe - ColN1	5
	Summe - ColN2	33
Gamma	Summe - ColN1	47
	Summe - ColN2	109

which is not at all useful!
The other possibility leads to the table

	ColA		
Daten	Alpha	Beta	Gamma
Summe - ColN1	54	5	47
Summe - ColN2	56	33	109

which is better, but still not usefull.

If this is not a bug, please give a hint how to achieve the wanted table. 
Thanks!
Best regards!
Comment 1 Terry Yang 2012-09-07 03:00:54 UTC 
Confirm at my side, Can't create such Pivot table, Try with MS office, it can create such Pivot table