+ Reply to Thread
Results 1 to 2 of 2

Sorting Pivot Table by Grand Total

  1. #1
    Registered User
    Join Date
    04-13-2006
    Posts
    3

    Sorting Pivot Table by Grand Total

    I have a pivot table to sum data (premium). I have two variables in the columns (company and state) and one variable in the row (class) to show the grand total of premium by class depending on which company and state are chosen. I'm having a hard time arranging the data so it is sorted by size of grand total - every time the table is rearranged, the grand total column moves and the data must be resorted. Is there a way to automatically resort the data every time the table is changed?

    Any help on this matter would be greatly appreciated!

    Thanks,
    Meg W

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Response

    You might try a macro linked to the sheet_change event. I can't immediately see another way of doing it.

    Martin
    Martin

+ 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