How to filter hierarchy by level?

[mortifikator]

Hi,

I am trying to find a way to filter hierarchy by level in Cognos Report Studio..
e.g. I have a hierarchy of org. units, and I'm creating a report on expenses per org. unit, and I want to see expenses of all level 1 org units, and all level 2 units, and all level 3 units etc. (each level separately). Like if I aggregated data for let's say level 1, and then drilled down to level 2, except I want to drill down to all level 2 units at once (not just by one level 1 path through hierarchy).

Here's an example:

Level 1: HQ
Level 2: SU11, SU12, SU13, SU14
Level 3: SU111, SU112, SU121, SU131, SU132, SU133, SU134, SU141

if I choose for example level 2, I want to have a table like this:

SU11 SU12 SU13 SU14
Expenses 100 200 150 123

Can this be done using drill down (let's say, I click on SU11, and I get a similar table only with ALL level 3 subsidiaries as columns), or if not, how can it be done?

P.S. Please have in mind that I'm very new to Cognos.

Many thanks