Want to know the Top 5 Expenses from the list of your expense? Then what’s better than using the filter option. You can filter the top 5 Expense Report in a pivot table. Want to know how to do it? Then what is the wait for? Let’s get started.
How to Filter Top 5 Expense Report
For example, you have a list of expense reports with you and you want to know the top 5 areas where you are spending more, then to know that we have to follow a few steps.
Step 1: Insert a Pivot Table. For knowing this click on – How to insert a Pivot Table.
Step 2: Click on the down arrow button.
Step 3: Click on Value Filter >> Top 10.
Step 4: You will get a dialog box, where you can choose Top 5 items by Sum of Amount as shown in the image below.
Step 5: Click on OK.
Here, you can see that these are the Top 5 spending areas.
So, this is how you can easily filter top 5 expense report in pivot table.
For more information visit our YouTube channel.