+ Reply to Thread
Results 1 to 4 of 4

Sorting Pivots by Ranges

  1. 12-14-2021, 01:08 PM #1
    eNinjaInTraining
    eNinjaInTraining is offline
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    75

    Sorting Pivots by Ranges

    Can someone advise on how I would sort these (attached) pivots by quantity (left pivot) and dollar (right pivot) ranges from least to greatest? These are hard-coded values on a data sheet that I'm needing to sort for analysis. Any advice appreciated!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-14-2021, 01:42 PM #2
    DJunqueira
    DJunqueira is offline
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Sorting Pivots by Ranges

    Sorted data in the file attached.

    Sort data in a PivotTable or PivotChart
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 12-14-2021, 02:48 PM #3
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Sorting Pivots by Ranges

    i understood it in a different way, 2 options :
    or you create your own custom list to sort and use it afterwards
    or you do it with VBA
    Attached Files Attached Files
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
    Reply With QuoteRegister To Reply
  4. 12-14-2021, 04:06 PM #4
    eNinjaInTraining
    eNinjaInTraining is offline
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    75

    Re: Sorting Pivots by Ranges

    Thanks, everyone!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Charts/Pivots with number brackets/ranges
    By piggyboy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-18-2021, 07:08 AM
  2. Report with Pivots where the pivots move to accomodate each other - is it possible?
    By andrewjmdata in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-27-2020, 11:06 AM
  3. How to add multiple ranges, charts and pivots to an email output
    By derpygoat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2014, 12:09 PM
  4. [SOLVED] Insert Slicer for Pivots Only or can we use it for Charts without Pivots?
    By eldwardo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2013, 04:27 AM
  5. Sorting 2 data ranges by comparing one column in each and sorting to match
    By MDKsmiffy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2013, 03:30 PM
  6. [SOLVED] I would like to build macro's to do pivots or part of pivots
    By Todd F. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2005, 11:05 AM
  7. Pivots ranges and INDIRECT
    By daveydave60 in forum Excel General
    Replies: 0
    Last Post: 04-21-2005, 10:59 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1