Manipulation of rows to columns

building reports webintelligence
1

I have a report that I have created that will have multiple rows of data in some cases for each employee. I need to switch this from multiple rows to one row. I would need to make new columns specific to each service and status or I need it to be a maybe a cross tab as shown in the attachment as well.

How do I create this report within the business obejects arena? Is it possible?

I’m BRAND new to this so you may have to dummy down your reply!

Thanks so much.
sample2.xls (13.0 KB)

lajutown (BOB member since 2008-09-19)

2

Hi,
Jsut remove the service name from the report
Regards
Kumar

kumar446 :india: (BOB member since 2006-01-23)

3

Create a local variable based on Status, and specify it as a Detail object with Service Name as the associated dimension. You should then be able to create a crosstab as per your example

Chas :uk: (BOB member since 2004-10-26)