Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Transforming a vertical table into an horizontal table in Business Objects

The report I have in Webi currently look like the table below:

Site ID WO ID Task Task ID Task Status

2BE3063C 1237116 1 14950 Open

2BE3063C 1237116 2 14951 Open

2BE3063C 1237116 3 14952 Open

2BE3063C 1237116 4 14953 Open

I would like to transform the table to this form, using formulas:

Site ID WO ID Task ID Task(1) Task(1) Status Task(2) Task(2) Status Task(3) Task(3) Status

I can't figure out which formulas, or functions to use, or even if it is possible to done this in Webi. Any help in this regard will be greatly appreciated.



Not what you were looking for? View more on this topic or Ask a question