Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Trying to create a view that contains yearly data from 2008 but only want to display the 5 most recent years up to the last item. I always want the view automatically sorted from oldest to newest based on a date column that is entered when a new item is created. I do not want to use the 'created' or 'modified' fields to do this because the list will then select items based on the most recent edited items which could then screw up sorting by the year. Essentially this view will select a rolling 5 year period where the user can enter in a new item for the new year and it will shift all of the data to account for the new record. I can do this if I sort from newest to oldest and limit the view to only 5 records, but I want it then sorted again so that the oldest record is on the top and then the most recent on the bottom. Any way I can do this?

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.