The Most Viewed Videos of all Time
Welcome
Login / Register

Advanced Pivot Table Tricks #7 - Top 10 Filters

Thanks! Share it with your friends!

URL

You disliked this video. Thanks for the feedback!

Sorry, only registred users can create playlists.
URL


Added by Admin in Top 10
35 Views

Description

#top10Filter #ValueFilterPivotTables #HowtoTop10Pivot

By default Pivot Tables will show all of your data. What if you want to limit the information to just top 10 records. For example, you want to see which of the sales persons are top 10 in a given region? You can use value filters to easily set up such conditions. 


For example workbook and resources visit:

https://chandoo.org/wp/advanced-pivot-tables/

Post your comment

Comments

Be the first to comment
RSS