Show Top Ten Results - Excel PivotTable Tricks

Filter your Excel PivotTable to display only the top ten results. This technique can be really awesome in Excel dashboards when space is limited. See more PivotTable tricks on the Advanced Excel Tricks course - https://bit.ly/3CGCm3M This video tutorial shows how to filter for the top ten results in an Excel PivotTable dashboard. The dashboard is set up with Slicers for interactivity. The top ten selling products created in the lesson complete the dashboard. The video also shows how to stop columns from autofitting when data is filtered. This is a really useful skill when creating interactive dashboards. You can also get your PivotTable to display the top 5, or top 15 results. It can also be used to display percentages such as top 10% or bottom 10%. Here are the timings for the video. 00:00 - Introduction 01:55 - Create the PivotTable 03:42 - Show top ten in Excel PivotTable 05:26 - Connect the Slicers to the top ten PivotTable 06:17 - Stop PivotTable columns widths changing Find more great free tutorials at; https://www.computergaga.com ** Online Excel Courses ** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ►   / 18737946   Instagram ►   / computergaga1   Twitter ►   / computergaga1