• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

How can I sort data items in a unique order that is not ascending or descend...

How can I sort data items in a unique order that is not ascending or descending?

Problem

Figure A.8 shows the default sequence of regions in a pivot table report. Alphabetically, the regions are shown in sequence of North, South, West. If your company is based in California, company traditions might dictate that the West region should be shown first, followed by North and South.

Figure A.8. Company traditions might dictate that the Region field should be in West, North, South sequence. Unfortunately, neither an Ascending sort order nor a Descending sort order can help you.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint