Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Sorting a Pivot Table
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Debra Dalgleish, post: 3779426"] Because you have two fields in the row area, the Sum Of Account Commission will sort within each Client Code, not over the entire column of totals. You could add a column in your source and combine the client code and client name fields. For example: =A2 & " - " & B2 Then, remove the client code and client name fields from the pivot table, and add new field instead. Then you should be able to sort on the Total column. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Sorting a Pivot Table
Top
