Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [grouping]

A collection of objects that share a similar characteristic.

0
votes
1answer
13 views

Creat a view with Sharepoint List: Sort by column then filter everything but the most recent

I have a list coming in from forms with a serial number and a date: [Serial Number] [date] a-6/10/19 a-6/12/12 a-2/4/14 b-3/2/15 b-4/1/12 I want to create a view where I only display the most recent ...
0
votes
0answers
30 views

Jquery Datatable Grouping 2 levels (Group and SubGroup)

I'm trying to group datatables using SharePoint List RESTAPI and I get to accomplish level grouping and I want to group level two as subgroup. Please let me know if that's possible. The picture below ...
1
vote
2answers
72 views

How to Sort or Filter by Group By Total - SharePoint Online

I have a long list of companies (3,500+) in a classic SharePoint list. I am trying to identify when there is a duplicate company. Right now I am grouping the Company Name field and scanning through ...
2
votes
2answers
22 views

Changing a View doesn't reflect on a page

I've modified my "Wanted" view of a classified ads list, grouped by Category, so that it doesn't display the annoying "Category:" text on each line. That works flawlessly when viewing the list ...
2
votes
0answers
98 views

Filtering a Grouped By view by current year in SharePoint Online

I am aware of this and have done this multiple times before and it used to work fine. However, currently I am facing unexpected behavior and it's different in Modern and Classic views. I have a list ...
0
votes
1answer
17 views

SP2013 Document Library: multiple value lookup and group by based on the values selected

SP2013 environment here. I have a document library that will need to have Manufacture Column (A,B,C .. etc) and a Model Column (Based on Manufacture Column), (like A1, A2, A3, B1, B2, B3, etc) The ...
0
votes
1answer
27 views

CQWP Group by Content Type

Is there a way to group by content type in Content Query Web Parts (CQWP)? I have created a list with 4 content types. We need to display the items in a CQWP but grouped by content type. I have tried ...
2
votes
1answer
94 views

calculate total of group in grouping view of splist

I need to calculate the number of group in my grouping view of SharePoint list. we can also calculate the number of different value in the column. Any idea how we can do that using JSOM.
0
votes
2answers
132 views

SharePoint Libary takes 10 minuntes to load on SharePoint Online

Hope you're well; I have sharepoint libary which takes 10 minutes to load. there 1500 files. How do I make it faster to load. kind regards, Anees
0
votes
0answers
11 views

Grouped List Webpart won't Paginate

I have viewed a previous question that is similar to this, but there are some differences that are making it hard for me to find a solution. I have a page with promoted links, and a list view of items ...
0
votes
1answer
31 views

How to display the title of the group in sharepoint list view?

I have this dispay. Notice the number right after the "Periode" group heading. I want that. Notice that the group heading is now have 2018-06 near the number of elements inside the groupe. Notice ...
2
votes
0answers
26 views

Grouping issue on a content query

I have created a content query pulling in a summary of the page library content. When I group the content based on “Topic”, I get the correct result for how I want the page organised, however all the ...
2
votes
1answer
36 views

Documents not showing in custom view

I have created a custom group-by view in a document library. In the All Documents view, I can see all the documents I have added to the library, but when I switch to the custom view I am unable to ...
1
vote
0answers
83 views

Web Parts - Unable to Collapse a List Group by Default

First question on this site and this is probably stupid and I'm overlooking something glaringly obvious but here is goes. Background I just recently rebuilt our site in SharePoint Online (2016) from ...
0
votes
1answer
72 views

Multiple Group By Categories

I have the following columns in the list. I want to create a view where items are grouped in the following manner: 1st grouping by State|| Another column that shows grouping by Sector || Another ...
0
votes
1answer
168 views

I need to work out a way to output the total from a list based on items

as an example I have a list with "flt Num" (flight Number) and "Weight" (PAX Weight). The weight is collected from 1 of 4 scales at checkin. The flight number is created after booking according to ...
1
vote
1answer
16 views

List groupings repeating values when document library is added to page

I have a custom list displayed on a page. In the view for this list has a filter and a grouping. When I add a document library to the page, the groupings display all of the filtered items under each ...
0
votes
1answer
39 views

Sharepoint view: group wrong!

I have a list with 2 field, [Date] (Datetime) and [Month] (calculated column = text(date,"YYYY/MM"), I want to group the list by Month, but Sharepoint group it wrongly! How can I fix it?
0
votes
1answer
47 views

Help with subtracting from a group total in a list

What i am trying to do is create a list where i can add entries that staff received for Time Off Awards. In my organization time off awards can not go over 80 hours yearly. I have created a list view ...
2
votes
0answers
174 views

SharePoint 2013 - How to enable collapse view in a list with web part connection?

I have two lists that are connected in the same page via web part connection. This way, I can filter one of them using the other. However, since there are many inputs, I would like the view to be in ...
3
votes
1answer
561 views

Can i group documents by using lookup column with multiple value?

One document belongs to many row. It is allowed . But I want to group them and show the document on each group. Is it possible ?
3
votes
1answer
50 views

SharePoint Column grouping in Library

I have three column in a library namely: Category , Sub-Category and Year. The type of this column are choice. I select a value in Category (lets say: Name), the name gets grouped.It's fine Next,...
5
votes
0answers
349 views

SharePoint Search Results Webpart returns wrong results count

I am trying to develop a custom paging control for my search results webpart but I am facing a weird issue that the search results return wrong total results count. Below is the javascript snippet I ...
1
vote
1answer
66 views

Group By View Ordering

Scenario: Created a list library and want to group by choices in look-up column titled Compass (North, West, South, East). I want to put the choices in order but not in alphabetical order. Problem:...
0
votes
1answer
836 views

OnPostRender not working on grouped list view web part

Hi I have a view where I'm grouping the list based on two columns and I would like to add some CSS to the cells containing "Green", "Red" etc. I have created a JS method colorCoding which takes care ...
3
votes
2answers
2k views

SP2013 Custom list: Customize group order/sequence

I have a huge custom list with several columns. They are grouped by e.g. Status, but the order of the groups cannot be influenced as it is strictly alphabetical. Is there a (nice) way how to customize ...
3
votes
1answer
34 views

SP 2013 Calculated Column that groups data choices

I am having trouble adding a calculated column that groups the data from the previous column into separate teams. I was thinking that the IF([column1]='A' 'B' 'C')THEN('Team1') IF([column1]='D' 'E' '...
1
vote
2answers
270 views

List items not visible when grouped by drop down choice

When I group the above list by the Status field the list items are not visible. If I group by a different field, the groups work correctly
0
votes
1answer
398 views

Group by more than 2 columns in SharePoint 2013 in Data view Webpart

http://www.dotnetsharepoint.com/2015/05/group-by-more-than-2-columns-sharepoint.html this link which was mentioned earlier didnt worked out for me though i followed each and every step properly. Can ...
0
votes
1answer
165 views

Group child content types under their parent content type in the same list

the title pretty much says what I need. Let's say I have two list items derived from two custom content types with the following fields: ContentType1 ID: 1 Title: "Item1" ContentType2 ID: 2 Title: "...
3
votes
2answers
123 views

Showing top 5 with grouping

I have a list that collects customer sales data (multiple records can contain the same customer). I am trying to create a view that will show the Top 5 customers based on sales. I need to have the ...
0
votes
1answer
232 views

Get count of items in a Grouped View using JavaScript

is there a way to get the count of items in a Grouped View via Javascript? The grouped view already has a count, but want to pass along that count to another object (a chart) and can't get past the ...
3
votes
3answers
57 views

How to make an item appear in two groups in a list view?

Say I have these items on a list. Apple Banana Orange Yellow Red I want to create a view where the items are grouped by the "attribute" column. Fruit ▼ Apple Banana Orange Colour ▼ Orange ...
1
vote
1answer
2k views

No Sort/Group by Content Type? [closed]

When editing a View, there is no option to Sort or Group by Content Type. This could be very useful for making a folder-like experience, for finding files, or other use cases. What design criteria ...
2
votes
1answer
73 views

SP 2013 view: Count in group complete / total

I have a standard list view with grouping by period, which shows me only total count in group. I'd like to add one more parameter to display, based on calculated column with yes\no output and ...
0
votes
1answer
25 views

Vertical Scroll Bars in Group By View

I am looking to add a scroll bar to replace the 1-15 per page view. Is this possible to put a vertical scroll bar instead of having the 1-15 option? If so how do I go about doing this? I currently ...
0
votes
1answer
200 views

Group by in webpart page with URL filter webpart

I think this might be a bug. But wanting to check if it is me doing something wrong or if it is genuinely a bug... I have a sharepoint webpart page. It includes a list view webpart, as well as a URL ...
1
vote
0answers
115 views

Sort View based upon a specific order of a lookup column

Our standard setup when a department requires a document library with document types is to create a separate Custom List for the Document Types so a power user within that department can add new ...
0
votes
1answer
339 views

Group By SPListItem in SharePoint SPListItemCollection

I have custom list. with calculated column Department Group. Department group column takes first left letter of title columns in uppercase. using SPListItemCollection I'm able to get all items. but ...
0
votes
1answer
38 views

How to View tasks by Assigned to

View does not offer to set a group by "Assigned To". I am looking for a view where I can group by people "Assigned To". If a task is assigned to more than one person, that task should appear either ...
0
votes
1answer
3k views

How to Group by more than 2 columns in SharePoint 2013?

A year and a half back, a guy posted this question here in the community. Group by more than 2 columns in SharePoint 2013? I read the answers and I followed the steps as provided in the given link ...
1
vote
1answer
203 views

Document library View problem after enabling SharePoint Server Publishing Infrastructure

I am site collection administrator in SharePoint Online. I enabled SharePoint Server Publishing Infrastructure in Site Collection Features. Now Views in my document library (/sites/sitename/Shared%...
2
votes
1answer
272 views

How to group custom App parts in a single group/category?

I have many app parts which i want to be under single group or category. So, when i will go in the "Edit mode" of the page, I will see my apps in a separate category. Please refer the below picture: ...
0
votes
1answer
275 views

Use LINQ GroupBy with SPListItemsCollection

I have a SharePoint list containing some items. I would like to apply grouping to the items using LINQ, preferably with .GroupBy method. This is the list of fields that the list item is consisted of: ...
1
vote
1answer
206 views

Link to Grouping Categories

I would like to create a link that will take me directly to the grouping section in a list. This is similar to page anchors on a word document. Is this possible? Update: This is a custom list not ...
1
vote
0answers
84 views

Hide ECB item in SharePoint 2013 list view with grouping implemented on it

I came across this answer - https://sharepoint.stackexchange.com/a/115553/32642 It works perfectly if list view don't have grouping. But in case of grouping it is not working. Can please any one ...
1
vote
0answers
44 views

List group shows entire list

I have a Enterprise SharePoint 2010 list view that is grouped by a choice column and shows the number of items in that group but when I expand any group it shows the entire list instead of just the ...
2
votes
2answers
6k views

Grouping sharepoint list using REST API

I have a sharepoint list with 4 columns one with the name and rest all with the numbers. I need to groupby name and need to sum the remaining columns. Please help me how it can be achieved using REST ...
1
vote
1answer
5k views

Missing SharePoint List Column in List View Group by section

I have a list with single line text, Choice and dropdown list columns. I would like to group the dropdown list column But I see the dropdown column missing in the group by section of list view. Can ...
1
vote
0answers
396 views

Group list by choice column

I've got a list grouped by a choice column which offers 3 values (-, yes, no) by dropdown. Also I've activated the expand Option. When I view the list the groups are collapsed. If I change the ...