Issue 118849

Summary: pivot report produces rows instead of columns
Product: Calc Reporter: tommyads
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: polo8495
Version: OOO330m20   
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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