"The twists and turns" Excel skill hundred example 13. PivotTable sorting

How does a PivotTable report sort? What is the difference between the sort of normal data?

For example, we will report the transcript according to the students to summarize the total score, click on the total score to find that "sorting and screening" is made of gray, that is, can not be used, then we should be a summary of the results of the order?

If we select the data and then copy it, create a new sheet, paste it as a value and sort it out, here's how to sort it directly in the pivot table.

We see a small triangle behind the header of the school number and name, for example, we click on the small triangle behind the study number:

Click "Other Sorting Options", select a sort method, such as descending, then select the sorting sequence, select "Sum: Score", it means sorting by total score, high score on top.

After clicking OK, we can see the following effect:

This will allow you to see the sort effect.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

"The twists and turns" Excel skill hundred example 13. PivotTable sorting