+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Months Weeks

  1. 04-22-2017, 02:27 PM #1
    morerockin
    morerockin is offline
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    449

    Pivot Table Months Weeks

    Hello All,

    Please see attached.

    How do i get this pivot to show me Months or Weeks in the columns? It shows Quarters/Years, but I need Months/Weeks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-22-2017, 02:34 PM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Pivot Table Months Weeks

    Right click on any year --> Choose Group and click Years and Quarters to deselect them and click OK.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 04-22-2017, 03:13 PM #3
    yurttas
    yurttas is offline
    Registered User
    Join Date
    10-28-2008
    Location
    Turkey
    Posts
    88

    Re: Pivot Table Months Weeks

    .

    You should use helper column in data.

    File attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-22-2017, 09:13 PM #4
    morerockin
    morerockin is offline
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    449

    Re: Pivot Table Months Weeks

    Quote Originally Posted by sktneer View Post
    Right click on any year --> Choose Group and click Years and Quarters to deselect them and click OK.
    Winner winner chicken dinner
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Pivot table with new data each month, last 12 or 24 months wanted in pivot
    By Here2learn in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-17-2016, 05:06 AM
  2. How do I group days to weeks to my own specification without pivot table?
    By kooldis in forum Excel General
    Replies: 4
    Last Post: 02-19-2016, 05:08 PM
  3. Pivot Table in Weeks Tuesday thru Monday Adjustment
    By johnsor1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-12-2015, 03:45 PM
  4. VBA to Select Multiple Weeks in Pivot Table based on User Input
    By burrow.philip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2014, 11:36 AM
  5. Macro to select rolling/latest 6 weeks in a pivot table
    By prasannakr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2013, 03:59 AM
  6. Grouping Weeks to Month in Pivot Table
    By himanshututeja in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-18-2012, 01:59 PM
  7. Dividing monthly values into weeks automatically (some months have 5 weeks)
    By massimoo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2012, 03:20 AM

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