COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Revelator80 on 29 Jul 2010 02:54:52 AM

Title: Drill Down behaviour problem
Post by: Revelator80 on 29 Jul 2010 02:54:52 AM
Hi,
I have a list report based on DMR which has two columns for Category and Customer Sector with spend and target information data shown. The category and customer information is hierarchical and I have enabled drill up/down on the report. What I need is the ability to specify that when a sector is selected, only the category that you have clicked from is brought back on the drill (e.g. Health exists in both IT and Finance categories, if I click the Health sector in Finance I only want to see the next level down for Finance).
Any suggestions?