Report requirement

[#1]

Hi,

  I attached one of my report requirement  4 snapshots as named as Level1, Level2,Level3,Level4.

In Level1 : LOB, LOB Description as Dimensions.

total open amount, 0-30, 31-60 as Expressions

If click on LOB  + expand symbol only , it should go next Level2

In Level2:  It should display, particular LOB, LOB Description, Business Unit, Business Unit Description as Dimensions,

total open amount, 0-30, 31-60 as Expressions regarding particular LOB

In Level3:

When click on any Business Unit of Level2, it should go Level3.

Level3 contains particular Business Unit related  CustNos

In Level4:

When click on Level3 custno, that shows detailed of that particular custno.

How I can achieve that requirement, for that which table is recomonded straight or pivot

Could you please help me.

Thanks

MLNR