Formulas

How to Filter Top 5 Expense Report in Pivot Table

Pinterest LinkedIn Tumblr

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.

How to Filter Top 5 Expense Report in Pivot Table 1

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.

How to Filter Top 5 Expense Report in Pivot Table 2

Step 3: Click on Value Filter >> Top 10.

Filter Top 5 Expense

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.

How to Filter Top 5 Expense Report in Pivot Table 3

Step 5: Click on OK.

How to Filter Top 5 Expense Report in Pivot Table 4

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.

Related Posts

Write A Comment