Skip to Content
0
Aug 01, 2016 at 08:48 AM

How to Transpose Rows to columns

1019 Views

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.

Attachments

63.PNG (12.5 kB)
64.PNG (3.4 kB)