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
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
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
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
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 neededI cannot figure out a way to filter out the weekends (and holidays as well).
where hol_range is a range with the holiday datesPlease Login or Register to view this content.
Then filter the pivot table on r to leave weekends and holidays out.
Be careful to use absolute references for your range
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks