Excel Pivot Table: How to Show Top 10 Values
Автор: Cogwheel Learning
Загружено: 2022-07-25
Просмотров: 81120
Описание:
This tutorial shows you how to display a Top 10 in an Excel Pivot Table.
In this video, a pivot table summarizes some product sales. With a Top 10 Filter, I can quickly show the top products, and compare top and bottom product sales.
Use the Top 10 filter feature in an Excel pivot table, to see the Top or Bottom Items. You don't need complex formulas , just use built-in filters.
You can summarize your data by creating an Excel Pivot Table, and then use Value Filters to focus on the top 10, bottom 10 or a specific portion of the total values in your data.
For example, instead of showing the total sales for all products, use this type of filtering to show just the top 10 products, or narrow it down to the top 3.
Also, if you want to focus on the bad performers, you can use a value filter to find the bottom 5 products.
If you find that useful, please give a like to this video and subscribe to my channel🤓
Timestamp:
00:00 Intro
00:30 Step 1: Find the correct button
01:24 Step 2: Sort the pivot table
01:47 Now, you have your Top 10🤓
🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions: • 💰 Compound interest calculator template in...
🎥 Common errors: • 🚨 How to solve the #DIV/0! error in Excel
🎥 How to tutorials: • How to use UPPER in Excel
🎥 Regular functions explained: • BASIC EXCEL FUNCTIONS
Feeling generous? I like coffee.🤗
☕ https://www.buymeacoffee.com/cogwheel
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
