Shaggy Basil
New Member
- Joined
- Jun 6, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Hello board!
I have a pivot table where the rows are Last Call and Company Name. The Last Call column has dates and in my table I want to see the top-ten oldest dates and filter out the others so that's all I see. I'd like this to be automatic so when I update the data sheet with new dates now and then and hit Refresh, the table updates to the latest batch of Top 10 dates based on oldest.
I was unable to figure this out myself or find an article online so here I be. Thanks in advance!
I have a pivot table where the rows are Last Call and Company Name. The Last Call column has dates and in my table I want to see the top-ten oldest dates and filter out the others so that's all I see. I'd like this to be automatic so when I update the data sheet with new dates now and then and hit Refresh, the table updates to the latest batch of Top 10 dates based on oldest.
I was unable to figure this out myself or find an article online so here I be. Thanks in advance!