Pivot table error

krishnaa_kumarr88

New member
Joined
Sep 30, 2014
Messages
26
Reaction score
0
Points
0
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
 
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
 
Back
Top