How to Use the Content Query Web Part to Rollup Data in SharePoint 2013

The Content Query Web Part for SharePoint 2013 is a powerful tool that can be used to rollup data and aggregate content from SharePoint lists and libraries from a List, Site, or Site Collection.  In this post, we’ll walk you through how to add the Content Query Web Part to your SharePoint environment, as well as how to configure the Web Part and display rollup data.

Add “Content Query Web Part” to site:

  • On the Edit Page, select the Insert Web Part tab. From there, select Content Rollup from Categories, and then Content Query from the Parts list:

  • Upon completing the steps above, you should see the following:

Configure the Content Query Web Part to rollup data:

  • To begin, select the source where the data you intend to rollup is currently being housed. This can be a Site Collection:

  • A selected site and all of its sub sites:

  • Or a List:

  • Next, select the List Type and Content Type for the rollup:

  • With the Web Part, you also have the option to add Additional Filters in the event you need to filter data while performing the rollup:

  • Next, you have the options of adjusting the Presentation of your data applying different Grouping and Sorting settings:

  • Once you have completed configuring the settings for your data rollup, click Apply and Ok to begin aggregating your content.

Display rollup data:

Once you have successfully completed the steps above, and the data rollup process has finished, you will be able to see the data that you rolled-up in the Content Query Web Part:

 

Want to know more about out-of-the-box web parts available
for SharePoint 2013? Check out the complete series via the links below:

 


All SharePoint Versions

The web parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft® Office 365.

SharePoint 2013, 2016, 2019, Online (Office 365)

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials Suite


Essentials Plus Suite


Bamboo Premier Suite


Project Management Suite


Knowledge Management Suite


External User Manager


 

For more information on our product suites, contact us.

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!