locked
Group view by season in sequential order RRS feed

  • Question

  • I have a list that I want to group first by year from my [Year] column, then by season in my [Season] column.  I have created a Seasons list and use that is the lookup for my [Season] column choices. Short of creating a custom workflow to put in the Season ID into my list (hidden), what can I do to group my list by season? For example:  Fall, Winter, Spring, Summer? (it's an acadmic year)

    There are no mistakes; every result tells you something of value about what you are trying to accomplish.

    Friday, April 11, 2014 10:56 PM

Answers

  • Hi run4it,

    The easier way to do this is to add prefix to the group headings to allow ascending/descending sort to work, like
    (1)Spring (2)Summer (3)Fall (4)Winter

    If you wouldn’t like to use the prefix, follow the steps in below article to use SharePoint Designer to change the list view to XSLT view, use joined tables as a linked data source. Implement custom sort expression to use the groupindex column for the final render.

    http://tudorolariu.blogspot.com/2008/10/custom-group-order-in-sharepoint-list.html

    Thanks,


    Qiao Wei
    TechNet Community Support

    Monday, April 14, 2014 8:03 AM
    Moderator

All replies

  • if i understood correctly you need to group by season lookup in a list.

    You can go to view settings of the list, under group by settings select the season column and show groups in ascending.


    My Blog- http://www.sharepoint-journey.com|
    If a post answers your question, please click Mark As Answer on that post and Vote as Helpful

    Friday, April 11, 2014 11:25 PM
  • yes, but that is out of sequential order for the seasons. Winter comes after Fall!  :-)

    There are no mistakes; every result tells you something of value about what you are trying to accomplish.

    Friday, April 11, 2014 11:46 PM
  • Hi run4it,

    The easier way to do this is to add prefix to the group headings to allow ascending/descending sort to work, like
    (1)Spring (2)Summer (3)Fall (4)Winter

    If you wouldn’t like to use the prefix, follow the steps in below article to use SharePoint Designer to change the list view to XSLT view, use joined tables as a linked data source. Implement custom sort expression to use the groupindex column for the final render.

    http://tudorolariu.blogspot.com/2008/10/custom-group-order-in-sharepoint-list.html

    Thanks,


    Qiao Wei
    TechNet Community Support

    Monday, April 14, 2014 8:03 AM
    Moderator