How to Show Different Values in a Pivot Table
There are a lot of values data can be shown in a PivotTable. These values include:
Here is a pivot table showing all values in the default sum value.
In this practice, we are going to want to display the average bedrooms, bathrooms, and square feet of each. We will also summarize each value in the pivot table as needed.
There are two ways of changing the value. One way is via the pivot table tools as shown.
Click the arrows by a field and in the value field setting change it to average.
Or you can simply right-click the column on the Pivot Table itself and summarize the values as needed.
After summarizing all values as averages the end result will look like this.
Now we need to show the results largest to smallest based on average square feet. In order to do so, right-click on the pivot column and select sort>sort largest to smallest.
But how can we show the top 10 states by average square feet? In order to show the top 10 of a value in a pivot table simply go to the row labels>value filters>top 10.
This will prompt the options to pop up as shown below. Here we can choose to show from top or bottom, a chosen amount of values, and a format. In our case, we are going to leave those as default and select to have the data by the Average of SqFt.
Doing so will get us our final item in this practice.