+ Reply to Thread
Results 1 to 3 of 3

Manually adjust grouping in pivot table

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Berlin/Sweden
    MS-Off Ver
    Excel 2010
    Posts
    124

    Manually adjust grouping in pivot table

    I have two columns - one with values 1-15 - and the one other with text values. What I would like to do is to create three ranges of the number values. 1-3, 4-8, 9-15 and then put the text values in the correct range they've been associated with.

    A pivot table with grouping sort of does the trick and if I put in 5 in the "by" field I get three ranges - but they're not what I want. Is it possible to manually change to this to filter it by the range I want?

    Thanks.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Manually adjust grouping in pivot table

    You can manually group as needed. Select the row values you want to group - right click - click Group.

    See attachment for example.
    Attached Files Attached Files
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Berlin/Sweden
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: Manually adjust grouping in pivot table

    Yeah, that worked the way I wanted. Thanks! But it can be a bit cumbersome if you have a lot of rows. But it does the trick.

+ 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. Manually Sorting Pivot Table Row Labels
    By brandonkmoon in forum Excel General
    Replies: 5
    Last Post: 08-15-2014, 03:02 PM
  2. Replies: 3
    Last Post: 08-27-2013, 09:35 AM
  3. Manually update Label filters on pivot table eventually do this via vba
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2013, 11:39 AM
  4. pivot table - works manually not by macro
    By jnewl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2006, 08:50 AM
  5. [SOLVED] How do i adjust the page breaks in excel without manually dragging
    By vmart003 in forum Excel General
    Replies: 1
    Last Post: 10-18-2005, 08:05 AM

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