Sorting tables in large spreadsheets can become cumbersome when they have a lot of data, and that’s where our sort a pivot table by value comes to your rescue. After creating a pivot table in Excel, the data may sometimes seem to be arranged in the incorrect order. Excel provides a wide variety of sorting options for the pivot tables, which may be used to organize the data. This article aims to demonstrate how to sort a pivot table based on its values.
Sort A Pivot Table By Value Using Sort
You can use the sort function from the right mouse to sort your pivot table according to the ascending and descending order. You can easily do these to find the lowest and highest value in an order that will be useful to you.
Step 1: To sort the data in the pivot table, right-click on any cell in the table and look for the Sort option in the context menu. You will have two choices to choose from in the Sort list. The first option is to Sort the items from smallest to largest, and the second option is to Sort the items from largest to smallest.
Step 2: Let’s assume you want the total price number of products you have to be arranged in ascending order from lowest to highest. In this instance, choose any cell inside the column labeled “Grand Total,” Then, under the Sort menu, pick the option that allows you to sort the data from smallest to largest. After these steps, the results will appear at the following location.
Sort A Pivot Table By Value Sort & Filter Option
We can also use the Builtin sort and filter option from the Data tab of the ribbon to sort a pivot table by value in any order you want. This is also one of the easier options.
Step 1: Excel is equipped with a built-in option to sort and filter data, which can be used for the regular table or the pivot table. To carry out this task, choose a cell inside your Pivot table, and then go to the Editing section of the Home tab, where you will see an option labeled Sort & Filter.
Step 2: You will notice two choices: one that sorts from the smallest to the largest and another that sorts from the largest to the smallest. When you choose the option to Sort Largest to Smallest, the values in your table will be arranged in descending order, beginning with the most significant. Following selecting the option to Sort Largest to Smallest, the ensuing result in your pivot table will look as shown below.
Sort A Pivot Table By Value By Condition
We can also set a condition for data sorting by using the built-in sorting function of the pivot table. You will only need to click the downwards arrow and use the greater than the value from the drop-down menu. We are going to set a greater than value for our data range.
Step 1: First, we have to click the downward arrow on the pivot table, and from the drop-down menu, select the Value Filters and select the greater than and another pop-up will come.
Step 2: Now, we can use the pop-up box to set the product’s price that is more than the price of 40. Pressing ok will clear the range of anything priced less than 40.
Use More Sort Options For Sort A Pivot Table By Value
Columns are the typical location for sorting functions to take place. However, there is a greater variety of sorting choices available, and you may do the sorting for rows with relative ease. You will need to activate the dialogue box labeled Sort by Value to do this. Simply choose a cell in which you wish the sorting to take place, and the Sort by Value dialogue box will appear for you to use. Now, use your right mouse button to select that cell, and then under the Sort dropdown box, choose the More Sort Options option.
Step 1:
Use the previously used Pivot table.
Click on the downward arrow.
Click the More sort options.
This will give you a popup to select more options.
Step 2: Form the menu. You can select which criteria you want the data to be rearranged. You will get the columns, and you can reorder in Ascending or Descending order after you are done; just press the ok button to apply the reconditioning.
Conclusion
After reading this tutorial, it is my sincere goal that you will find utilizing pivot tables to be less of a challenge for you. In this part, I went through various methods that may be used to sort Pivot Tables based on their data. If you have any ideas or reactions to this article, please leave them in the comment box below. Keep your connection active to access even more fascinating information. You now have four simple options to sort a pivot table by value. If you practice them for a while, you’ll have no trouble picking them up.