Notice, the pivot table remains unsorted, but I can easily sort in descending order using the rank field. Now when I save these settings, we have a rank value in the pivot table. This will be the field that you are using to summarize data, which in this case is Item. Now, whenever you rank with a pivot table, you need to set a base field. In this case, we want largest to smallest. In the dropdown, near the bottom, you'll find an option to rank values from smallest to largest and largest to smallest. This is done with Value Field settings under Show Values As. Now I need to change the display to show rank. In this case, I want to rank total sales, so I'll simply add the Amount field again, and change the name to "Rank." The first step is to add the field you want to rank in the Values area. Now, what if I want to add an actual rank value to the pivot table? Now, looking at the pivot table, we can see that tents are the top item by sales, followed by car racks, sleeping bags, backpacks, and finally headlamps. I'm going to rename this field "Sales," and set the number format to Currency. In fact, after I summarize the data with a pivot table, I can get an exact list of items sold by adding the Item field to the Rows area.Īnd, when I add Amount as a value field, I'll get a breakdown of total sales by item. You can see the store sells tents, backpacks, headlamps, and so on. Here we have data that represents one month of sales for a camping store. In this video, we'll look at how to rank data in a pivot table.
0 Comments
Leave a Reply. |