+ Reply to Thread
Results 1 to 1 of 1

Filtering categories in Pivot Chart

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    34

    Filtering categories in Pivot Chart

    This may be so obvious but for some reason I cannot get the hang of it.

    The example file is attached. I am trying to create a pivot table with the 'Type of Program' filter automatically displaying values based on what is selected in 'Tactic' area. Right now, if I select 'Media' from 'Tactic' menu, I can see all the different programs under 'Type of Program'. What I want to do is when one selects 'Media', one is only able to see associated 'Type of Program' with it.

    So, once 'Media' is selected from 'Tactic' tab, one should only see 'IFE' and 'Tray Tables' instead of seeing all the other categories.

    Is this achievable?
    Many Thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1