I have a requirement where the drill should take me to a report which would provide one additional level of granularity by default.

here is an example:

Org: Highest Level
Sub Org: One level Down
Cost Center Hierarchy: One more Level down
Cost Centers: Lowest Level.

On the Reporting, I have a Column Picker for all 4 columns mentioned above.
When the user chooes to drill in from Org, the DrillTo report would show, Org and Sub Org columns selected.
When the user chooes to drill in from Sub Org, the DrillTo report would show, Sub Org and Cost Center Hierarchy columns selected....You get the idea.

I can achieve this by having multiple reports..But...maintenance associated with it. It would be great to achieve this with a same report.

Has anyone gone came across this use case? Any suggestions/ideas?

HI Radha,

When you create the drill I would try and use the selections in the drill configuration to get the view you want:

Play around with each selection and hopefully one of them is what you are looking for. They dynamically change based on the parent report you drill from so you do not have to create multiple drill reports.

Thanks,

Lauren