4
votes
Accepted
Sorting grouped items in a list view
For other people who run into the issue of ordering Groups but do not want to add any other (visible)characters to the title here is a small tip.
Add spaces! More than one space is not shown in HTML ...
- 156
4
votes
How to group distinct values from a list using odata rest api
I know it's a relatively old post but, for anyone who's still looking for an answer on this, querying for both grouping and aggregations(Totals) is supported in REST. Following are the two links for ...
- 215
2
votes
Accepted
OnPostRender not working on grouped list view web part
I found the answer here. It uses hooking into ProcessImn SharePoint function which supposedly gets called on expanding any group according to the answer.
I modified my code as below and it is now ...
- 290
2
votes
SP 2013 Calculated Column that groups data choices
You will need to use OR with IF in order to achieve this. It will be something like this:
=IF( OR(Title="A" , OR(Title="B",Title="C"))
,"Team 1"
,IF( OR(Title="D" , OR(Title="E",Title="F"...
- 3,046
2
votes
SharePoint Column grouping in Library
OOTB SharePoint supports only two level of grouping. However, there is a step by step guide http://www.dotnetsharepoint.com/2015/05/group-by-more-than-2-columns-sharepoint.html to achieve this. You ...
- 1,266
2
votes
How to Sort or Filter by Group By Total - SharePoint Online
I don't think what you want to do can be achieved in SharePoint online. But it would be very easy to export the list to Excel and create a quick pivot table. Pull company name in the Row panel of the ...
- 9,129
2
votes
SPO - Remove or Disable the Group By metadata change
I have tried this on my tenant and found some strange behavior. Below is a workaround you could try:
Step 1:
When you group by 'Status' but do not include it as part of the displayed view columns ...
- 929
1
vote
Accepted
Chronological grouping of dates formatted as MMM YYYY in Sharepoint
When you use a calculated column to format a date the field becomes text and is then sorted alphabetically. What you want is to keep the field as a Date so that it is sortable (and filterable) in the ...
- 6,051
1
vote
Grouping, Summing, Filtering to join two SharePoint lists together in a Collection in PowerApps
To share with others who might be experiencing this same issue, I found a resolution.
The code that worked can be found below:
ClearCollect(
TotalofParticipantsPerClass,
AddColumns(
...
1
vote
Accepted
sorting after “group by” in a SharePoint Online list problem
Please following steps:
1.Sign in the list as an admin >> List settings
2.On the List Settings page, scroll to Views section and click on the specific view
3.On the Edit View page, scroll to ...
- 2,895
1
vote
SPO - Remove or Disable the Group By metadata change
I don’t think it is possible to disable this function.
It is what “Group By” do in SharePoint lists, as a filter.
- 4,592
1
vote
Accepted
How do I sort items that are grouped
Go in Modify View and check the settings under Group By - try changing it to descending and see what happens.
When you are using Group By it overrides the usual Sort By settings. BTW - I'm using ...
- 2,215
1
vote
Changing a View doesn't reflect on a page
Looks like that is a common issue - here is a similar question and possible answers > https://social.technet.microsoft.com/Forums/ie/en-US/5d1de812-acf4-49ff-96a3-a6a113025cf1/list-view-remove-group-...
- 121
1
vote
Accepted
calculate total of group in grouping view of splist
You can use the renderListData function on a list with JSOM to do the grouping.
Example:
SP.SOD.executeFunc("sp.js", "SP.ClientContext", () => {
var ctx = SP.ClientContext.get_current();
...
- 6,278
1
vote
Accepted
How to display the title of the group in sharepoint list view?
We can create a calculated column which would include the starting part of the item title "2018-06". And then by applying "GroupBy" to that particular calculated column. We can achieve it.
Follow ...
- 1,027
1
vote
Accepted
Documents not showing in custom view
It could be a field issue.
Try creating a simple text field and copying the Month/Year Calc value to it. Then try and group by the simple text field instead of Month/Year Calc. Does it allow you to ...
- 2,215
1
vote
List groupings repeating values when document library is added to page
this is a grouping bug , you need to enable server side rendering on your webpart
this is under :edit webpart/miscellaneous/server render
mark the checkbox and save, that should fix the issue
- 245
1
vote
Accepted
1
vote
Sorting grouped items in a list view
You can create a calculated column with a type "number".
=IF(category="Permissions","<span style='display:none;'>1</span>CategoryName","<span style='display:none;'>2</span>...
- 360
1
vote
Accepted
List items not visible when grouped by drop down choice
The dropdown choice had a tab and that's why it didn't work.
Changing the statuses from "1. Name" to "1.Name" meant the view worked
- 1,046
1
vote
Showing top 5 with grouping
This is not possible OOTB since Aggregation has no sorting parameter. This might be because the values are never stored it is calculated on the fly. You can achieve this through some code. Have a look ...
- 3,046
1
vote
How to make an item appear in two groups in a list view?
Basically you are looking to create a "Group By" view and allow the column that items are being grouped by to have multiple values for each item. To the best of my knowledge that can't be done, but ...
- 2,346
1
vote
No Sort/Group by Content Type?
How about Metadata Navigation for your App. It allows you to add content type as something that can be filtered on.
More info: https://support.office.com/en-US/article/Set-up-metadata-navigation-for-...
- 1,282
1
vote
SP 2013 view: Count in group complete / total
It won't be possible OOTB way. You can add another grouping based on Yes/No or Status but not both.
- 3,826
Only top scored, non community-wiki answers of a minimum length are eligible