Configuring List Rollup Definitions
All list rollups configured in a Site will be shown under ‘Manage List Rollup Definitions’ tab. Here we can Create, Edit, and Delete list rollups.
New List Rollup
1.Click on ‘New List Rollup’ button
2.Configuration settings
a.General Settings:
In General settings, we need to specify Title for List Rollup definition and whether to allow creation of list items directly from list rollup web part as shown below
Example with Actions in First Column:
b.Define columns for this rolled-up list:
Here we need to create columns to show in List Rollup web part which are later mapped with SharePoint columns from Rolled-up lists.
Click on ‘New Column’ button to create columns for list rollup web part
c.Configure lists for this rollup
•Click on ‘Add List’ button to configure lists to rollup
Select Site, List and View from which data should be retrieved to show in List rollup
Click on ‘New Column Mapping’ button to map list rollup columns created in step 2(b)
Column Color Settings
Configure Color settings on columns in the list rollup by specifying conditions based on which color gets displayed in list rollup web part. Click on ‘New Color Setting’ button to create a new setting.
Example: ‘Status’ column in list rollup web part will be shown as shown below based on the specified values in color settings
Note: Similarly configure any number of lists in this rollup to show as a web part in a dashboard or web part page