Skip to Content
Former Member
Jan 16, 2018 at 08:22 PM

How to calculate total completions for each Direct report under a Top level employee


Hi ,

I have a requirement to calculate 'Total completions of each direct report (For ex: I am running a report for 'Top level employee' and he has 5 direct reports. Each direct report again will have (like a hierarchial nodes in BW) X number of employees under them. I am building a cross tab in Web intelligence (4.2 SP 2) and need to calculate the 'Total completions' for each direct report. The datasource is Universe. Please suggest if anyone has any ideas on how to achieve this?