+ Reply to Thread
Results 1 to 3 of 3

Excel for Mac Pivot Table grouping

  1. #1
    Registered User
    Join Date
    02-19-2012
    Location
    Florida
    MS-Off Ver
    Excel for Mac v16.16.27
    Posts
    12

    Excel for Mac Pivot Table grouping

    I have Excel for Mac 16.16.17. I am trying to create a pivot table from a data group that has customer age, item bought, price & date. I can get the table to give me a count of items bought by age of customer (i.e 21,22,23,24 etc) but I want to create groups of ages - not just individual age (i.e. 20-25, 26 -30, etc.). The PivotTableAnalyze -> Group Selection returns an Alert, cannot group that selection. Ideas?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Excel for Mac Pivot Table grouping

    Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-19-2012
    Location
    Florida
    MS-Off Ver
    Excel for Mac v16.16.27
    Posts
    12

    Re: Excel for Mac Pivot Table grouping

    I figured it out. Some of the age figures had a ‘+’ after the number. Got rid of those and it works fine. Thx.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Grouping Dates in a Pivot Table - Excel for Office 365
    By WinginSue in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-02-2018, 01:42 PM
  2. Replies: 1
    Last Post: 07-22-2015, 07:16 AM
  3. Excel 2007 pivot table loses grouping and filters if no data
    By jamesanderson in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-28-2015, 03:32 PM
  4. Grouping Dates in Excel Pivot Table
    By mskennedy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2013, 09:33 AM
  5. Replies: 1
    Last Post: 06-05-2012, 04:52 PM
  6. [SOLVED] Pivot Table Grouping (Excel 2000)- This has to be simple
    By uncoolfester in forum Excel General
    Replies: 5
    Last Post: 10-21-2005, 11:05 AM
  7. [SOLVED] Grouping in Excel on a Pivot table, need to be able to retrive ex.
    By Rhonda/FHSB in forum Excel General
    Replies: 2
    Last Post: 05-16-2005, 05:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1