+ Reply to Thread
Results 1 to 3 of 3

cannot group selection in pivot table

  1. #1
    Registered User
    Join Date
    05-01-2008
    Posts
    29

    cannot group selection in pivot table

    I'm missing something - please help.
    I've read http://www.contextures.com/xlPivot07.html#Problems and reformatted my dates to see if that is the problem. I still get "cannnot group that selection". I want to group by month and it just isn't happening. Sample attached. Can someone please tell me what is wrong?
    Thanks in advance.
    Cindy
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-08-2007
    Posts
    93

    Pivot Table Grouping

    The problem isn't with your date formats - it's that you're trying to use the same field for both the row header (which you want to group on), and the data section. Add a column to your pivot table called "item_cnt", populate it with 1 for all rows, and use that for your data. Then you can group on then date field.

  3. #3
    Registered User
    Join Date
    05-01-2008
    Posts
    29

    Thanks

    Seckert, Thank you for trying to help. I can't get it working. I have been fiddling with this for days. It's time for me to give up and do it manually. Thanks so much for trying. Sincerely, Cindy

+ 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