Skip to Content
0
Former Member
Aug 27, 2010 at 11:26 AM

BI Query

8 Views

Hi Experts,

Can you pls. help me with the solution for below requirement,

I have DSO (A)where I'm getting utilized hours for particular Employee and DSO (B) where total allocated hrs., so now in the report I need utilization percentage on particular project wise. formula is (Utilized hrs/total hrs) * 100.

pls. note that Project is assigned for Employee in DSO (A), and Project is not Assigned for DSO (B)., so my current out is

with out project

Employee utilized hrs Total hrs %

A 34 40 86

above output is fine, but when we drilldow project,

Project Employee utilized hrs Total hrs %

X A 34 0 0

  1. A 0 40 0

but now I need to populate this total hrs when Project is drill down as well.,

Can any body help me in providing the solution,

Cheers,

RK

Moderator message: Please add a suitable subject