Excel 2013 pivot table sort top 10 by month

[ItBusinessAnalyst]

Hi,

I have an excel pivot table which stores the total number of times a specific code is used per month.

I would like to know if there is a way to filter the top 10 in the pivot table by month instead of grand total.

I would like to keep just one pivot table but have the results of the top 5 for each month shown.

Thanks,

 

[Tanner_2004]

Excellent question I would like to know the same.