Results 1 to 4 of 4

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

Threaded View

  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

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