+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 Pivot help required

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Excel 2010 Pivot help required

    I have a pivot table which is taking data from another sheet of the same file, at page filter I have date field which range from Jan 01, 2003 to Nov 30, 2012(format mm/dd/yyyy). How can I select data e.g. from Aug 01 2010 to Nov 30 2012. One way is to select each date one by one, is there any efficient way to do this.
    Thanks

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Excel 2010 Pivot help required

    Hi

    Make sure the dates are excel dates (numeric) then after applying the pivot right click a date in the pivot table and select group, then group by day AND month

    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    12-06-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel 2010 Pivot help required

    Great Thanks lot!!!!!

+ 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