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

Applications

SharePoint apps are stand-alone applications that perform specific tasks on a SharePoint site. Apps can perform functions such as managing a discussion board or knowledge base, performing project management or time tracking tasks, or doing other workflow operations.

SharePoint

Product Suites

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


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


SharePoint

Web Parts

Extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of Web Parts. Web Parts are the building blocks of pages on a SharePoint site that can be used to customize the user interface and content of a site page. 

SharePoint

Product Suites

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


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


Office 365

Cloud Parts

Cloud Parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft Office 365. More than mere ports of existing software to the cloud, our Cloud Parts have been built from the ground up to take advantage of the best that the cloud has to offer.

SharePoint

Product Suites

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


Cloud Parts Suite for O365/SP Onl.


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!