How to rank with a pivot table

Tip: How to rank with a pivot table

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.


Leave a Reply

Your email address will not be published. Required fields are marked *