Results 1 to 3 of 3

Pivot - sorting of report filter

Threaded View

  1. #1
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Pivot - sorting of report filter

    Hey guys,

    I have a report that i submit every week which contains several pivots. I have included 1 pivot in the attached file. When additional records are added to the pivot source and even after refreshing, the Customer(All) field is not arranged in alphabetical order. This only works when the pivot is created the first time. All incremental records go one below the other and does not join with the existing records to arrange itself alphabetically. This Customer(All) field is a report filter as shown.

    How do i ensure that this field gets sorted each time the pivot is refreshed? I also thought of deleting the pivot and re-creating a new one everytime data is added to the source. However, there are several other pivots and formulae that are connected to this pivot which will get messed up if i delete it.

    Appreciate your help.

    P.S - I have attached the file and the screenshot of the pivot field that requires sorting.
    Attached Images Attached Images
    Attached Files Attached Files
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

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