Results 1 to 4 of 4

Using a pivot table to sort on values only

Threaded View

  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

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. 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