cancel
Showing results for 
Search instead for 
Did you mean: 

How to Transpose Rows to columns

former_member349215
Participant
0 Kudos

Hi Experts,

One of our clients is running SAP Business One, Version for SAP HANA. They have an Annual Production Report which shows the amount of Item Gruops produced (Kgs) per month in a certain year. This is a simple query output; it shows Item Groups received for the month of January=1

However, I would like some guidance on how to achieve this below. Group Name and Summmed Quantities are tranposed to Columns



Kind Regards,

Pascale.

View Entire Topic
former_member349215
Participant
0 Kudos

Solved

Decided to create crosstabs using crystal reports. It produced the intended report

Learn more about crosstabs here:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/b03a1e04-a2b9-2d10-d792-88d8755843d7&override...

Kind Regards,

Pascale.

0 Kudos