Skip to Content
0
Former Member
Jul 23, 2014 at 06:36 PM

Aggregating values across rows and columns on a Bex Query

453 Views

Hi,

I am working on a Bex 3.x query. I need to aggregate data in the following manner. Please see the example below

WBS Element Employee Hours Total WBS1 EMP 1 10 35 WBS2 EMP 2 12 34 WBS 3 EMP 1 15 35 WBS 1 EMP 3 17 17 WBS 2 EMP 1 20 35 WBS 1 EMP 2 22 34

Basically how I display the totals column is the challange. For every employee , the aggregate hours across any WBS element need to be shown on the totals column for the row that displays that employee.

Please tell me how I can configure this on the Bex query.

Thanks,

Shweta