How to Use the Content Query Web Part to Rollup Data in SP '13

The Content Query Web Part for SharePoint 2013 is a powerful tool that can be used to roll up data and aggregate content from SharePoint lists and libraries from a List, Site, or Site Collection. In this post, we’ll show you how to add the Content Query Web Part to your SharePoint environment, as well as how to configure the Web Part and display roll-up 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 roll up 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 option of adjusting the Presentation of your data by 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:

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

View All Products

Small Business Pricing and Discounts

Learn More

SharePoint

Top SharePoint Online Products

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

Calendar Plus

Carousel

Employee Directory Plus

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 2016, 2019, 2022 – Classic Pages Only

View All Products

SharePoint

Top On-Premises Only Products

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

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