Results 1 to 5 of 5

Macro to adjust pivot table's date filer for last week

Threaded View

  1. 10-23-2017, 09:02 AM #1
    taylorsm
    taylorsm is offline
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Macro to adjust pivot table's date filer for last week

    My only PT filter is a date filter. I need to set it to only include last week. M-F. Regardless if I run this on a tuesday or thursday, it should return the same results for the previous week. Can this be done? Also, I have my PTs to be Top 3 values, is there a way to make it stop at 3. What happens most commonly is I have 1,2,3,3,3. Is there a way to stop it at 1,2,3?
    Last edited by taylorsm; 10-23-2017 at 11:54 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to get week-over-week % in pivot table for dissimilar data
    By adityag85 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2016, 05:54 PM
  2. [SOLVED] Generic macro to adjust the source data for a pivot table
    By scottiex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2016, 11:41 PM
  3. Dynamic pivot filer
    By astolz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2014, 06:24 PM
  4. Pivot table field for day of week vs. Date return
    By MARKSTRO in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-19-2014, 06:18 PM
  5. Pivot table week grouping date format
    By meprad in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-04-2013, 06:37 AM
  6. [SOLVED] Macro to update pivot item (date format) in pivot table to latest date from data source.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 03:18 AM
  7. Filer within Pivot Table
    By Rob in forum Excel General
    Replies: 2
    Last Post: 08-14-2005, 06:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1