Results 1 to 2 of 2

Thread: Pivot table error

  1. #1

    Pivot table error



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Does any one knows how to sort the pivot table based upon the row color.
    There r 3 colors,
    Red,
    Amber and
    Green.

    I want red to come on the top, next amber and finally green.

    I tried by using Data->Sort option but its showing error as

    "you cannot move a part of Pivot table.........."

    Thanks

  2. #2
    If Colour is a column in your pivot, you can setup a custom list and use that in your sort by right-clicking the field in your pivot table and select Sort>More Sort options>Manual>More options>untick Sort automatically>Fisrt Key Sort order>choose your Custom List

Posting Permissions

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