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!
When I click on say, "London", all that happens is the table changes and only shows "London" on one line with a Total. In other words, it doesn't do anything except remove all the other offices. What I want it to do is when I click on London, it changes dimension to 'Staff' and shows the staff relevant to "London".
That is my understanding of a drill down.
I suppose what I need to know is, is my understanding wrong or is my workbook wrong?!
For example if you create group with office name and Staff Name and then used in a table instead of dimension
Initially the Table shows all the data belongs to Office Name(Dimension), When ever you click on any one of the Category from Office Name, Then the table show for Staff Name(Dimension) , Staff Name Data Corresponds to that specific category selected in Office Name.
First Displays : Office Name -- >if u select any Category -->Staff Name Data Appears(Only for category selected in Office Name)
In Cyclic Group, it has list of Dimension like Office Name and Staff Name, You can either select Office Name or Staff Name. You Cannot Get any Hire achy in Cyclic Group.