+ Reply to Thread
Results 1 to 3 of 3

Auto-Filtering a Pivot Table?

  1. #1
    No Spam
    Guest

    Auto-Filtering a Pivot Table?

    Dear Excel 2003 Users,

    I created a fairly nice pivot table that feeds a chart showing the
    amount of hours for all of the different clients that a person has
    worked on. Management liked it but asked a question that left me
    scratching my somewhat empty head. Is there any way to filter out the
    "less important" clients - e.g. clients that were worked on for less
    than 5 hours?

    The data for the pivot table originates from an Access database, so I
    guess I could always do it there, but I was hoping that there was some
    way to have a pull down (similar to the pivot table pull down for the
    employee names or client names) on the pivot table sheet that had a
    list like this:

    Top 10
    Top 3
    Greater than 10 Hours

    Is anything like this even remotely possible? Thanks a million in
    advance!

    Kevin

  2. #2
    Ken Wright
    Guest

    Re: Auto-Filtering a Pivot Table?

    When you say it originates from an Access database, are you actually
    querying the database or is the raw data now dumped into Excel and you have
    pivoted from there?

    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ------------------------------*------------------------------*----------------
    It's easier to beg forgiveness than ask permission :-)
    ------------------------------*------------------------------*----------------


    "No Spam" <nospam@earthlink.net> wrote in message
    news:4i7so1tvek7ck5qmiqptdjustok94g1060@4ax.com...
    > Dear Excel 2003 Users,
    >
    > I created a fairly nice pivot table that feeds a chart showing the
    > amount of hours for all of the different clients that a person has
    > worked on. Management liked it but asked a question that left me
    > scratching my somewhat empty head. Is there any way to filter out the
    > "less important" clients - e.g. clients that were worked on for less
    > than 5 hours?
    >
    > The data for the pivot table originates from an Access database, so I
    > guess I could always do it there, but I was hoping that there was some
    > way to have a pull down (similar to the pivot table pull down for the
    > employee names or client names) on the pivot table sheet that had a
    > list like this:
    >
    > Top 10
    > Top 3
    > Greater than 10 Hours
    >
    > Is anything like this even remotely possible? Thanks a million in
    > advance!
    >
    > Kevin




  3. #3
    Ken Wright
    Guest

    Re: Auto-Filtering a Pivot Table?

    If you just wanted to show the Top x customers then right click on one of
    the customer names, choose field settings, advanced, Top 10 Autoshow = on
    and Show Top x, using field Sum of Hours or whatever your field is called.

    Regards
    Ken...................

    "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
    news:eSoaNmf9FHA.3660@TK2MSFTNGP09.phx.gbl...
    > When you say it originates from an Access database, are you actually
    > querying the database or is the raw data now dumped into Excel and you
    > have pivoted from there?
    >
    > --
    > Regards
    > Ken....................... Microsoft MVP - Excel
    > Sys Spec - Win XP Pro / XL 97/00/02/03
    >
    > ------------------------------*------------------------------*----------------
    > It's easier to beg forgiveness than ask permission :-)
    > ------------------------------*------------------------------*----------------
    >
    >
    > "No Spam" <nospam@earthlink.net> wrote in message
    > news:4i7so1tvek7ck5qmiqptdjustok94g1060@4ax.com...
    >> Dear Excel 2003 Users,
    >>
    >> I created a fairly nice pivot table that feeds a chart showing the
    >> amount of hours for all of the different clients that a person has
    >> worked on. Management liked it but asked a question that left me
    >> scratching my somewhat empty head. Is there any way to filter out the
    >> "less important" clients - e.g. clients that were worked on for less
    >> than 5 hours?
    >>
    >> The data for the pivot table originates from an Access database, so I
    >> guess I could always do it there, but I was hoping that there was some
    >> way to have a pull down (similar to the pivot table pull down for the
    >> employee names or client names) on the pivot table sheet that had a
    >> list like this:
    >>
    >> Top 10
    >> Top 3
    >> Greater than 10 Hours
    >>
    >> Is anything like this even remotely possible? Thanks a million in
    >> advance!
    >>
    >> Kevin

    >
    >




+ 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