I have a weekly report where I need to publish the top five alarm incurred for the prior week. I must publish the alarm count for the five alarms for that week as well as the prior. Currently, I use a pivot table discover the top five and their associated counts. I then create another pivot table using the same criteria that I did for the current week and change the week number but also have to do the tedious part of filtering to bring up the top five alarms found in the original pivot table.

Is there a way to accomplish this task without having to do the additional filtering and possibly without having to select the prior two weeks manually?