In this article we will explain, how to create multi level group by more than two columns.
We are having a list with name “RajamouliFilmography”, now we want to create multi-level hierarchy “Group By “with more than 2 levels.
In OOTB it’s not possible to create more than 2 levels of Group by, but using SP Designer we can achieve this functionally.
Open the Site in SharePoint Designer
Click on Site Pages->In the Top click on web part page->select any page layout ->Enter the Page name.
Now click on the Page->Edit the file.
We placed the cursor inside the Zone Template, but Data View is in disabled.
In SharePoint 2013 we cannot add the Data View directly.
To enable Data View we have to convert the page in to HTML, for that click on the Parse HTML as shown in the below screen shot.
Again navigate to INSERT tab, there we can able to see the Data View is enabled stage, place the cursor inside the Zone Template, and click on Empty Data View.
Once we added the Empty Data View, in-between the Data Sources tag add the List.
Once we added the list, in the right hand we can able to see the Data Source Details.
Press Ctrl tab and select the columns that you want to give Group By, then click on Insert Selected Fields ->Click on Multiple Item View.
In the Option Tab Click on Sort & Group, it will pop a window, there we have to select the Fields and click on add that you want to give Group by
We added the fields in an order that we want to create group by Year, Film, and Hero Name, Select the Check box option for all the fields Show group header.
Click on Ok.
Save the page and then click on preview browser.
Now we can able to see the more than 2 levels of hierarchy structure.
Please let me know if anyone having quires on this article.