Results 1 to 3 of 3

Thread: Pivot Table

  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a pivot table where I am trying to sort based on the Topbox Percent. I have tried the sort function but it sorts on the count not the percent column. I have attached so you can see what I am talking about.
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Midwest, USA
    Posts
    108
    Thanks
    5
    Thanked 5 Times in 4 Posts
    If your pivot table is based on a query, just enter the word descending in the sort box of your percent field.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by John MacVean View Post
    If your pivot table is based on a query, just enter the word descending in the sort box of your percent field.

    There is no percent field. This is created in the pivot table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •