Compare Top and Bottom Products

pivot top 10

In this video, a pivot table summarizes the products sales over a two year period. With a Value Filter, you can quickly show the top products, and compare top and bottom products.

Video: Compare Top and Bottom Products

To see the steps to compare top and bottom values in a pivot table, please watch this short Excel video tutorial. It shows how to set up the Top 3 filter, then copy that pivot table, and change it to show the total for the bottom products.

Top Selling Products

An Excel pivot table is a great way to summarize a large amount of data, and with a Top 10 filter, you can show the top products, or the worst selling ones.

For example, you can see the 3 items that have the best sales totals.

pivottop10filter01c

Total for Bottom Selling Products

It’s nice to know what is selling the best, but you could also take a look at the products with the lowest sales. A Top 10 filter can have its settings changed, to show the bottom items, as you can see in the screen shot below.

If the top 3 products have a total sales amount of 136K, how many of the low selling products does it take to equal that amount?

Use these settings for the Top 10 Filter:

  • Bottom – 136000 – Sum – by Total Sales

Using this pivot table feature is a great way to see how your sales efforts are paying off. Are you spending most of your time promoting products that aren’t profitable?

More Top 10 Filter Info

You can find more examples of Top 10 filters in a pivot table on my Contextures website, on the Top 10 Filters page.

There are many ways to use this pivot table feature, when analyzing your data. Don’t stop at just viewing the Top 3 – dig deeper, to see what else is happening.

A pivot table makes it easy to pull out these numbers – much easier than creating complicated formulas, and more flexible too.

_______________________

One thought on “Compare Top and Bottom Products”

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.