+ Reply to Thread
Results 1 to 4 of 4

Unable to Group a Number Range in Pivot Table (Excel 2016)

  1. #1
    Registered User
    Join Date
    11-13-2018
    Location
    Arizona, USA
    MS-Off Ver
    MS Office 2016
    Posts
    16

    Unable to Group a Number Range in Pivot Table (Excel 2016)

    Hello! I've been working on this all day and I've checked out many internet search questions regarding this issue, but I can't find a way to solve my problem - hopefully someone here has the answer!

    I have attached my workbook, with the two tabs (one with the raw data, and one pivot sheet). In my first column, you will see that there are a bunch of numbers (they represent numbers of days past due). I have made sure that each of those numbers are formatted as numbers with 0 decimal points. There are no blank cells in my column. Whenever I try and group, I get an error message box saying this selection is unable to be grouped. Any suggestions?

    Thank you so much!
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Essex, UK
    MS-Off Ver
    various
    Posts
    2,591

    Re: Unable to Group a Number Range in Pivot Table (Excel 2016)

    Hi, have a read of the below from Debra Dalgleish's site, more specifically the OLAP section:

    https://contexturesblog.com/archives...t-table-items/

    In short, you will need to recreate the Pivot but when doing so do not check the box to add to data model... you should then find you can Group your field(s).

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Unable to Group a Number Range in Pivot Table (Excel 2016)

    I do not know if I understood your needs well. I did grouping with Power Query.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-13-2018
    Location
    Arizona, USA
    MS-Off Ver
    MS Office 2016
    Posts
    16

    Re: Unable to Group a Number Range in Pivot Table (Excel 2016)

    XLent - Thank you for that site - it was VERY helpful! It didn't occur to me that the "data model" had anything to do with it, but clearly it does. Stasinek - and thank you for looking at my work and fixing it with something that I am very anxious to learn more about - power query and power pivot!

+ 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. Pivot table row height excel 2016
    By siddiq1212 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-11-2018, 03:03 AM
  2. UK Tax Period April 2016 to March 2017 Sort Group Pivot table
    By thorrrr in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2018, 01:32 PM
  3. Excel 2016 - Pivot table not refreshing
    By Cubicle Convict in forum Excel General
    Replies: 1
    Last Post: 05-31-2017, 10:11 AM
  4. Can't Sorting pivot table value in excel 2016
    By igoodable in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-18-2017, 03:38 AM
  5. [SOLVED] calculating specific data from a pivot table to create a pivot chart in Excel 2016
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-15-2016, 12:14 PM
  6. Excel 2016: Pivot table dates - useless!
    By domgilberto in forum Excel General
    Replies: 1
    Last Post: 02-17-2016, 01:43 PM
  7. Unable to group dates in a pivot table despite formatting the column
    By MaxwellR in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-11-2013, 07:12 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