Group by views in a list

Hi,

I have a list on my SharePoint site with a view on it where I group by a particular column. This column has 5 possible values. How can I ensure that a header for each value is shown whether or not there is data corresponding to that value

For example - say that the column name is "Status" and it can have values "Open", "Closed" and "Pending". How do I show a header for a status of "Pending" if i don't have data for my list with this status

Thanks.



Answer this question

Group by views in a list

  • jerfoo

    There is no way to force the header to show up since it does not show up in any of the rows. SharePoint does not look at the group-by field and determine all possible values for it (since it could be a text field and have basically an unlimited number) but rather it gets all the rows in the list and groups by the values that exist for the column in question.



  • Group by views in a list