Sorting pivot table by year/criteria...

[Sanador]

I'm imagining/hoping this is a stupid question, but here goes... I have a large table of sports data including, among others, the following columns:

DATE | YEAR | NAME | GOALS | ASSISTS

I've created a pivot table using NAME and YEAR as the Rows and Assists as the Value. I've been able to sort the list such that i have a list of names sorted by descending values for assists in a single year. Unfortunately, names are missing. For example, Jane Smith is listed in second place with 60 assists, but not shown again even though she should place 4th as well with 51.

I hope this makes some sense and that I've missed some simple pivot table magic. Any advice is appreciated.

 

[tcardwell]

Hello Sanador,

I think you are looking for Design>Report Layout>Repeat All Item Labels.

 

[Sanador]

Thank you for the reply! Unfortunately, that didn't do the trick. If it helps, I'm not even seeing the number that should be in (for example) 4th place. I currently have the Row Labels YEAR field sorted by ASSISTS in descending order with the value set to Top 10, 1 Sum with the goal being obtaining a list of the top assist numbers in a given year, listing the name and year that each occurred.

Hello Sanador,

I think you are looking for Design>Report Layout>Repeat All Item Labels.