In this video, we’ll look at how to rank data in a pivot table.
Here we have data that represents one month of sales for a camping store. You can see the store sells tents, backpacks, headlamps, and so one. In fact, after I summarize the data in a pivot table, I can get an exact list of items sold by adding the Item field to the Rows area.
And, when I add Amount as a value field, I’ll get a breakdown of total sales by item. I’m going to rename this column “Sales”, and set the number format to Currency.