In this article, you’ll create a simple PivotTable and then use the built-in filter to display only the top 10 records in the data source. LEARN MORE: Office 365 Consumer pricing and featuresįortunately, Microsoft Excel has a built-in filter for PivotTables that will let you display the top (or bottom) n record. TechRepublic and the author were not compensated for this independent review. When you want to see only the top n records-filtering out all other records-you’ll need a different strategy.ĭisclosure: TechRepublic may earn a commission from some of the products featured on this page. Either is reasonable when you want to view all of the data. In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet, I explain two different conditional formatting methods to highlight the top n values in a data set in Microsoft Excel. Top Tech Conferences & Events to Add to Your Calendar in 2023 How to Create a Local Account in Windows 11 Pro Support for these Microsoft enterprise products ends in 2023 Image: muchomor, Getty Images/iStockphoto Must-read Windows coverage For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews.
We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10. How to display the top n records in an Excel PivotTable using built-in options
0 kommentar(er)
