Can Hierarchy Nodes be summarized in Bex?

Hello experts,

We have a query the uses a CostElement (CE) hierarchy and CostCenter (CC) in the Rows area. The CE hierarchy has 3 levels; the CEs that are posted to are all on level 3. Levels 1 and 2 are used for grouping purposes and always end with "99".

Upon execution, the results are as follows:

Lvl | CE | CC | $

1 | 689999 | 2001 | 25

1 | 689999 | 2002 | 7

1 | 689999 | 2003 | 5

1 | 689999 | Result | 37

2 | 680099 | 2001 | 25

2 | 680099 | 2002 | 7

2 | 680099 | 2003 | 5

2 | 680099 | Result | 37

3 | 680020 | 2001 | 25

3 | 680020 | 2002 | 7

3 | 680020 | 2003 | 5

3 | 680020 | Result | 37

The desired result is:

Lvl | CE | CC | $

1 | 689999 | Result | 37

2 | 680099 | Result | 37

3 | 680020 | 2001 | 25

3 | 680020 | 2002 | 7

3 | 680020 | 2003 | 5

3 | 680020 | Result | 37

In other words, we want to summarize the nodes at levels 1 and 2 since they are not posted to directly. This will eliminate redundant entries of CostCenters at levels 1 and 2.

We have tried several options using Structures vs. Hierarchy and workbook formating but are unsuccessful so far.

Any suggestions are greatly appriciated!

Regards,

Adam