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:

 


SharePoint Online

The cloud parts are functional components that extend your SharePoint Online environment in Microsoft 365.

Supports Classic and Modern sites for SharePoint Online/Microsoft 365

SharePoint

Top SharePoint Online Products

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


Calendar Plus


Chart Plus


Knowledge Base


Project Management Central


Simple List Search

 

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 – Classic Pages Only

SharePoint

Top On-Premises Only Products

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


Calendar Plus


Data Viewer


Password Change


Password Expiration


Password Reset

 

Our team of Microsoft 365 experts help you get the most out of your Microsoft technology, we have the best Microsoft 365 talent to streamline your organization.

Streamline Your Department

We Have What You Need

Bamboo Solutions

Tools


Resources


Bamboo Installer