+ Reply to Thread
Results 1 to 4 of 4

Pivot Table: Formatting grouped values

  1. #1
    Registered User
    Join Date
    07-08-2009
    Location
    Hixson, TN, USA
    MS-Off Ver
    2010
    Posts
    20

    Pivot Table: Formatting grouped values

    Please see the attached screenshots of a Pivot Table. This is a Pivot Table with a numerical column as the rows with the values grouped into class intervals. In other words, the Row Labels in the screenshot are class intervals of a numerical column.

    In the first screenshot (one on the left) the numerical values are grouped with default starting and ending values. I tried to format the numbers so that they will have two decimal places but could not. Then I changed the starting and ending value to 0 and 1 respectively. This is seen in the second screenshot, the one on the right. Now, I am not able to sort the values in addition to not being able to change the display format.

    It looks like the row labels are text even though the column used for rows is numeric. Is there a work around to format the class interval values so that they look professional?
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by dileepan; 02-20-2021 at 01:31 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Pivot Table: Formatting grouped values

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-08-2009
    Location
    Hixson, TN, USA
    MS-Off Ver
    2010
    Posts
    20

    Re: Pivot Table: Formatting grouped values

    Thanks Richard, I have attached the Excel file, it has the data and the pivot table. The Row Label column is a numerical column grouped into class intervals.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,526

    Re: Pivot Table: Formatting grouped values

    This is more of a work around than a solution.
    Add another column to the raw data that rounds the values in the propensity column to two decimal places.
    Use the new column in the Rows area of the pivot table.
    Group the values and sort least to greatest (I still had to manually drag the 0-0.1 group to the top).
    I hope that this will be somewhat helpful.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Pivot Table values grouped by month do not appear in column format
    By DAVID766 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-01-2019, 01:17 PM
  2. Pivot Table Grouped by Interval
    By heather1209 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-20-2017, 07:38 AM
  3. Replies: 3
    Last Post: 03-29-2015, 03:14 PM
  4. Pivot Table: Grouped Frequency Distribution
    By HP348 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-30-2012, 04:16 PM
  5. Pivot table - average of grouped sum
    By is49460 in forum Excel General
    Replies: 2
    Last Post: 10-19-2011, 03:10 AM
  6. Formatting grouped horizontal axis of Pivot Chart
    By tunaaa in forum Excel General
    Replies: 9
    Last Post: 09-05-2011, 04:44 AM
  7. Pivot table grouped results
    By BRFx2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2006, 03:35 PM

Tags for this Thread

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