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?