I am having some trouble with something that hopefully isn't as difficult as I'm making it out to be.
I have trying to use the pivot table top filter on an inner row field count. Thus far, I can only seem to get it to give the top 5 outer rows. I want all outer rows present, while only the top 5 inner rows remain.
I hope this is possible, and I am missing something simple.
Thanks in advance!