+ Reply to Thread
Results 1 to 2 of 2

pivot table sorting problem

  1. #1
    Registered User
    Join Date
    11-25-2020
    Location
    Toronto,Canada
    MS-Off Ver
    365
    Posts
    2

    pivot table sorting problem

    Hi there,

    I have pivot table sorting problem. I am trying to sort descending the Market value which is in "Values" field which doesn't work. I am trying to sort asset from largest to smallest. I tried to put the market value in row field but It didn't work.

    I really appreciate your help!

    Thanks,
    E
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    5,216

    Re: pivot table sorting problem

    You can only sort within the existing groups in a pivot table, so you can't just sort the entire table by the market value, if that's what you want?
    Rory
    I drink, and I know things

+ 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 sorting problem when table has two columns
    By SwissExcel in forum Excel General
    Replies: 5
    Last Post: 12-08-2016, 03:39 PM
  2. Pivot Table Sorting Problem
    By Excel8449 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-09-2016, 02:49 PM
  3. Pivot Table Sorting Problem
    By kevsvette in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-02-2015, 03:24 PM
  4. sorting problem w/ pivot table
    By jyl7 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-22-2013, 06:30 PM
  5. Pivot table- sorting with value filter problem
    By Masun in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-02-2013, 03:55 AM
  6. Regarding Pivot table sorting problem
    By ramki in forum Excel General
    Replies: 3
    Last Post: 08-06-2009, 02:36 AM
  7. Pivot table (calculation and/or sorting) problem
    By jringo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2008, 09:38 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