Group by Multiple Levels in a View in an Online SharePoint List
Hi guys! I looked through the functions in a SharePoint List and I heard that we could group data by some columns. In addition, we could also group data by 2 levels in a view in SharePoint List.
Let’s say this is an example table in an online SharePoint List:
Date of JourneyFarNearStatusLow Medium High8 June 2024Very FarVery NearActiveMedium LowAverageHigh
As far as I know, a SharePoint List also allows users to group data by 2 levels in a view, which is illustrated below:
Date of Journey Far Near Low Medium High
Date of Journey:: 6/8/2024
June 8
Status: Active Very Far Very Near Medium Low Average High
I’m wondering whether an online SharePoint List allows users to group data by multiple levels (more than 2 levels) in a view.
Let’s say this is an example of an expanded version of the above table in an online SharePoint List:
Date of JourneyFarNearStatusRemaining HoursProgressAlertLevel of SpeedQualityLowMediumHigh8 June 2024 Far NearActive8 HoursSlowImmediateFastBad LowAverageLow
I want to group data by multiple levels, let’s say by 4 levels in a view, which the intended outcome in the SharePoint List would look like this:
Date of Journey Far Near Remaining Hours Alert Level of Speed Low Medium High
Date of Journey:: 6/8/2024 Far Near
June 8
Status: Active 8 Hours
Progress: Slow Immediate Fast
Quality: Bad Low Average Low
I have seen the documentation that if I want to group data with more than 2 levels, I would need to use the “Filter” function together with the function of 2 levels to achieve that, but I’m not sure how to go about it. Therefore, I need help to group data by 4 levels in a view in the SharePoint List and the intended outcome would look like the one above. Any methods and techniques are appreciated, thanks in advance!
Hi guys! I looked through the functions in a SharePoint List and I heard that we could group data by some columns. In addition, we could also group data by 2 levels in a view in SharePoint List. Let’s say this is an example table in an online SharePoint List:Date of JourneyFarNearStatusLow Medium High8 June 2024Very FarVery NearActiveMedium LowAverageHigh As far as I know, a SharePoint List also allows users to group data by 2 levels in a view, which is illustrated below: Date of Journey Far Near Low Medium HighDate of Journey:: 6/8/2024June 8 Status: Active Very Far Very Near Medium Low Average High I’m wondering whether an online SharePoint List allows users to group data by multiple levels (more than 2 levels) in a view. Let’s say this is an example of an expanded version of the above table in an online SharePoint List:Date of JourneyFarNearStatusRemaining HoursProgressAlertLevel of SpeedQualityLowMediumHigh8 June 2024 Far NearActive8 HoursSlowImmediateFastBad LowAverageLow I want to group data by multiple levels, let’s say by 4 levels in a view, which the intended outcome in the SharePoint List would look like this: Date of Journey Far Near Remaining Hours Alert Level of Speed Low Medium HighDate of Journey:: 6/8/2024 Far Near June 8 Status: Active 8 Hours Progress: Slow Immediate Fast Quality: Bad Low Average Low I have seen the documentation that if I want to group data with more than 2 levels, I would need to use the “Filter” function together with the function of 2 levels to achieve that, but I’m not sure how to go about it. Therefore, I need help to group data by 4 levels in a view in the SharePoint List and the intended outcome would look like the one above. Any methods and techniques are appreciated, thanks in advance! Read More