Multiple column drill down at single click

[rprameshwor]

Hello All ,

Is  there someway i can drill down in multiple columns by clicking on a single column. ?

eg :-
I have 3 columns

Item , time [ Year -> Month ] , Org [ Region -> Location ]

Item | Time | Org
-----------------------
Itm1 | Year | Reg1

n when i click on Itm1 , then time and Org hierarchies should be drilled down to make the report

Item | Time | Org
-----------------------
Itm1 | Mnth1 | Loc1
Itm1 | Mnth1 | Loc2
Itm1 | Mnth2 | Loc1
Itm1 | Mnth2 | Loc2

Drill through might be a solution , but going with the drill through requires a lot of reports to be created in our case . So , anyways around this ?

Thanks in Advance ,

[Satheesh]

Hi,
Is This DMR Model or Relational Model...??
If you go through the DMR Models it is easy... It will com automatically....There you can use Tree prompt..

[rprameshwor]

Sorry , I forgot to mention in my Original Post . Yes, its a DMR Model.  And its a List Report with above mentioned columns.

and I dont understand , how it comes automatically.