I am working on a Bex 3.x query. I need to aggregate data in the following manner. Please see the example belowWBS 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.