Regarding the grouping of records.

building reports webintelligence
1

HI Friends,

I am using webintelligence. I have created a report, but my manager wants the report in different way. So, I am attaching the excel sheet as an attachment. Please find it and let me know the solution.
Example.xls (14.0 KB)

eswar519 (BOB member since 2009-05-26)

2

create 2 objects with formulae as below:
Project Work Hours :=
Sum([Daily Hours]) where [Project for Activity] <> “All Standard Activities”

Standard Work Hours :=
Sum([Daily Hours]) where [Project for Activity] = “All Standard Activities”

To create your report use the following objects:
ICR-Country
Resource Name
ICR-Functional Roles (Primary)
Project Work Hours
Standard Work Hours

amsmi :india: (BOB member since 2006-09-08)

3

Excellent Thanks

eswar519 (BOB member since 2009-05-26)