Show Top 5 , by each change in row label, of a Pivot Table? Is that possible?

pivot top 5 by row label.JPG

Year 1 and Year 2 can be ignored
Looking to return rows that represent:
Top 5 for Indemnity
Top 5 for Medical
And so on

The number of rows beneath each row label can vary with each data refresh. I used =LARGE and INDEX/MATCH and it worked great, until I realized that the data will be constantly shifting beneath each main row label (e.g. Indemnity, Medical, etc.)
The values can be returned in another range of the worksheet...doesn't have to be in the confines of the pivot itself.

Any ideas?

If you want the Top 5 items to display in the Pivot itself, right click on "Temporary Total Disability" (to engage appropriate source field), select Filter, select Top 5 by "Sum of Year 3".

Hmm. That worked within that one label, but the rest of the pivot has produced very odd results. I can't quite identify how it's trying group things, but it's falling short. Maybe what I'm after isn't possible.

Hmm... the attached should illustrate what I was suggesting -- i.e. top 5 (of third DATA field) relative to the "parent" level filters (page, row etc)

If this is doesn't do what you're looking for I'd suggest posting a sample file to better illustrate your requirements; images, as a general rule, don't really help as people won't have time to recreate.

I see the difference. In your example, there is a separate column for each sum grouping. In my data, the amounts are all in one column and the year is defined by another column (Year). Do you see what I mean?

This is the file. The last tab has the pivot in question.

I have no idea if I'm attaching this file correctly. I don't see it anywhere, when I preview this post.

Ah, I see, apologies I missed that -- so, no, I'm not sure you can do that assuming Years 1 & 2 need to remain visible.

Formula wise, you could likely isolate the relevant balances but you would, I think, want to:

a) modify the Pivot Report Layout (via Design) such that it is Tabular, and possibly
b) repeat the requisite item labels {via field settings -> layout & print}

I think it would be helpful if you can post a sample however, even if it's just a values-only copy of your Pivot (once you've applied a} above), along with the expected results.


EDIT: ignore point re: sample given your prior post -- I will try and take a look later today but, of course, others may respond sooner.

Excellent ideas. I will implement them and then suggest to my users that they copy what I've done for future reporting. I really appreciate the help!!!