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!
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.