+ Reply to Thread
Results 1 to 4 of 4

Using a pivot table to sort on values only

  1. #1
    Registered User
    Join Date
    10-26-2014
    Location
    Leavenworth, WA
    MS-Off Ver
    2010
    Posts
    82

    Using a pivot table to sort on values only

    Hi I am not sure if this is a pivot table solution or an advanced filter solution. FIRST THANK YOU, THANK YOU!!!!!!!!!

    OUTCOME: View each CLASS of employee (Certified, Classified Waive, etc) by PLAN with the EMPLOYEE 2 AMOUNT-not summed or counted.

    WHY? I want to see that each Certified Employee or CLASS is paying the same amount for the same plan.
    EXAMPLE: If I have one Certified employee paying 214.13 and one paying 399.17, for PLAN A, WHY? I will then be able to drill down and see why. On my original spreadsheet there are employee names that I deleted for this forum.

    Using a pivot table doesn't work because I need it to look something like this:

    PLAN A INSURANCE COMPANY
    Certified Employee pays x amount
    Certified Employee pays y amount
    Certified Employee pays z amount

    Plan B INSURANCE COMPANY
    Classified Waive Employee pays x amount
    Classified Waive Employee pays y amount
    Classified Waive Employee pays z amount
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Using a pivot table to sort on values only

    Convert the color filled range to an actual Excel Table and filter/sort columns as desired.
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-26-2014
    Location
    Leavenworth, WA
    MS-Off Ver
    2010
    Posts
    82

    Re: Using a pivot table to sort on values only

    That is awesome. Thank you.
    What is the table beside it?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Using a pivot table to sort on values only

    I'm not sure what you mean. All the data to the left is part of the original worksheet. When you filter the Table, rows are hid or unhid...

+ 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. sort pivot table by numerical values
    By pma85 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-16-2014, 04:49 PM
  2. Is it possible to sort pivot table by value?
    By jyl7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2013, 10:02 AM
  3. Sort table with only formulas...and not pivot table
    By agweyre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2012, 09:19 PM
  4. Is it possible to sort in a pivot table?
    By Bandini in forum Excel General
    Replies: 1
    Last Post: 02-21-2012, 09:51 AM
  5. Replies: 0
    Last Post: 11-11-2011, 04:10 PM
  6. Pivot Table sort by day
    By English_Bloke82 in forum Excel General
    Replies: 1
    Last Post: 04-07-2011, 08:57 AM
  7. Replies: 2
    Last Post: 05-19-2010, 05:14 AM
  8. [SOLVED] pivot table sort entries that don't yet appear in table
    By rachael in forum Excel General
    Replies: 11
    Last Post: 09-19-2005, 07:05 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