Pivot Tables

[markhib]

Hi Board,

i have a big table of data and have created a Pivot Table. within the table, there are branches and the people who work in each branch.

I have put the Office and the Person in the "Drop Page Fields Here" area. What i need to do is select branch first and then only have in the people list those people who work in the selected branch.

Can i get this to work???

 

[Dougie1]

Put the Branch on the Page, the People on the Row, and Count of something which is standard across your data set into Data