+ Reply to Thread
Results 1 to 4 of 4

filter out weekend\holiday days from a pivot table

  1. #1
    Forum Contributor
    Join Date
    02-04-2009
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    113

    filter out weekend\holiday days from a pivot table

    Hello,
    I have a pivot table with a 6 month list of days in the column section. I need to filter out though all the weekend and holiday dates. Can anyone think of a simple way to do this?
    Thanks much in advance,
    Nathan

  2. #2
    Valued Forum Contributor
    Join Date
    07-17-2005
    Location
    Abergavenny, Wales, UK
    MS-Off Ver
    XL2003, XL2007, XL2010, XL2013, XL2016
    Posts
    608

    Re: filter out weekend\holiday days from a pivot table

    Hi

    Can you post an example of your workbook?
    If so, then I am sure we can help you.
    --
    Regards
    Roger Govier
    Microsoft Excel MVP

  3. #3
    Forum Contributor
    Join Date
    02-04-2009
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: filter out weekend\holiday days from a pivot table

    Roger,
    Thank you for responding and sorry for the late reply. Attached is a copy of a test spreadsheet for our call center data. I cannot figure out a way to filter out the weekends (and holidays as well).
    In addition, I was wondering if it is possible to create the following type of pivot table. in one column showing the calls each agent recieved (I tally up the calls by placing te 'extension' column in the values field) and in the second column to show how many calls were recieved in that month and in the 3rd column to show the percentage of calls the agent recieved out of the monthly volume.
    I hope this isnt too much too ask and I sincerely appreciate your offer to assist.
    Nathan
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: filter out weekend\holiday days from a pivot table

    I cannot figure out a way to filter out the weekends (and holidays as well).
    You can add a helper column to your raw data to determine if it is a holiday or a weekday using the following in J4 and pull down as needed
    Please Login or Register  to view this content.
    where hol_range is a range with the holiday dates

    Then filter the pivot table on r to leave weekends and holidays out.

    Be careful to use absolute references for your range

+ 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