LinkBack URL
About LinkBacks
Is there someway to use the dynamic filter "xlFilterThisWeek" to filter a pivot table? I want to be able to sort to show only the current week. I know I can add a helper column but am looking for a VBA solution. Thanks for any help.
Is there someway to use the dynamic filter "xlFilterThisWeek" to filter a pivot table? I want to be able to sort to show only the current week. I know I can add a helper column but am looking for a VBA solution. Thanks for any help.
Last edited by jcranst; 07-01-2013 at 07:31 AM.
I got this to work but only if date is in the pivot table. Is it possible for it to sort by date without the date being shown in the pivot table? Like a slicer can do?
Please Login or Register to view this content.
Last edited by jcranst; 07-01-2013 at 08:15 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks