Apache OpenOffice (AOO) Bugzilla – Issue 118849
pivot report produces rows instead of columns
Last modified: 2012-09-07 03:00:54 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!
Confirm at my side, Can't create such Pivot table, Try with MS office, it can create such Pivot table