The List Consolidator Web Part display can be set to show consolidated data by default, as shown below.
|Group the Data. Drag and drop column headers to/from this bar to change the grouping and subgrouping of the consolidated data.
|Sort the Data. Click the header of a column to sort the list by that column. Clicking the same column a second time reverses the sort order.
|Filter the Data. Enter a value to filter by, then click the Filter Icon to select a comparison operator such as Equal To, Not Equal to, Contains, etc.
|Navigate. Use the icons to navigate between the pages of the display.
Click Modify View to return to the settings page in order to configure or re-configure the data retrieved and displayed.