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 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 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:

  • How to Use the Note Board Web Part in SharePoint 2013
  • How to Use the Script Editor Web Part in SharePoint 2013
  • How to Use Microblogging in SharePoint 2013
  • How to Use the Tag Cloud Web Part in SharePoint 2013
  • How to Use the Picture Library Slideshow Web Part in SharePoint 2013

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 2016, 2019, 2022 - 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

M365 Plus

Managed Services

We Have What You Need

Federal Contractors