Top 3 Values by Month

[kaylan]

Hello,

I am working on a project where I need to identify our top 3 clients per month for volume and revenue. Right now I have the data displayed in a pivot table but I am not having any luck applying the "Top N" filters -- and the ideal solution is not to create a separate table for each month. I'm fine with separate tables for volume and revenue though -- it gets too crowded to look at otherwise.

Is this possible? Or is there a simple solution that I have managed to overlook?

Thanks,
Kaylan

 

[James006]

Hi,

When it comes to filters applied to pivot tables, see link below :

Excel Pivot Table Filters - Top 10

Use Excel Pivot Table Filters to focus on the top 10, bottom 10 or a specific portion of the total values in your data.

www.contextures.com

Hope this will help