Results 1 to 4 of 4

Thread: Pivot tables

  1. #1
    Join Date
    Jul 2008
    Posts
    2

    Unanswered: Pivot tables

    Hi
    We have a pivot table (see attached file)

    What we need to do is we have multiple branch names associated with Team names, so when we click on a branch name in the dropdown, we only want to see the associated team names.

    Currently when we click on a branch name all teams are displayed.

    We then display the data.

    For example, Newcastle branch has the following teams associated: Casualty, Casualty 1, Casualty 2. Birmingham has Casualty Midlands, Casualty Southern. When we click on Birmingham, all of the teams appear, we only want those to appear that are associated with that branch.

    Hope that all makes sense!

    Can this be done?
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Your attachment appears corrupted...

    Can you tell me what language / software product you are using?
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2008
    Posts
    2
    its a simple Excel spreadsheet
    I`ve only zipped it up. Should open OK. Just tried it on my local machine.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Moved to Excel topic
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •