Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Sorry for the very basic question, and I have searched for the answer, honestly!
I have created a drill down group which is office name and staff name. I have a table set up showing various expressions by office and my plan is to have the table switch to staff name and show all the staff within the selected office.
At the moment, all that happens is the sheet is filtered by the office you select.
I am sure I am missing something very straight forward, and sorry again for the silly question!
Thanks
Share the group details screen shots, it will be helpful to find the solution
Here is the group set up..
Hi Paul,
Grouping was right, Its better to share sample app to better understand the problem.
Hi,
here's a sample of a drill-down group.
HTH
André Gomes
Hi all.
I have located the problem! My workbook is setup with a different Alternate state on each sheet - basically each sheet contains very different metrics. When I switched the Alternate state back to "Inherited", the drill down worked.
Is there anyway around this do you think?
Many thanks
Hi Paul,
Drill down group is not work in the alternate state..