+ Reply to Thread
Results 1 to 5 of 5

pivot table without sorting

  1. #1
    Registered User
    Join Date
    06-05-2019
    Location
    romania
    MS-Off Ver
    2016
    Posts
    44

    pivot table without sorting

    hy. ia have a pivot table in wich i want to keep de data order for PROIECT like in sheet1. in pivot sheet in column H, I put the values ​​as I would like to be displayed in the pivot tables.
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: pivot table without sorting

    You can manually sort the pivot table, just drag the rows and place them in the correct order.

  3. #3
    Registered User
    Join Date
    06-05-2019
    Location
    romania
    MS-Off Ver
    2016
    Posts
    44
    Quote Originally Posted by kersplash View Post
    You can manually sort the pivot table, just drag the rows and place them in the correct order.
    And for 1000 rows situation? Isnt a good solution

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: pivot table without sorting

    You may have to modify your data or somehow apply a custom sort.

  5. #5
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: pivot table without sorting


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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