Results 1 to 3 of 3

Pivot Table and Sorting by Month Only

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    59

    Pivot Table and Sorting by Month Only

    Hi,

    I have a pivot table and I want to display results by months only and not by multiple days. I know I can go into date filters and sort by a specific month but what I want is to have the pivot table display by months only without the specific days, with all months showing

    In essence, I want an September, October, November etc field without the specif days.

    Am I making sense. See attached sample.

    Thanks and this site is so helpful.
    Attached Files Attached Files
    Last edited by Peeekay; 11-12-2010 at 11:53 AM.

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