Open the Consolidator Enterprise for Excel dialog box and start consolidating as shown below.
Select the corresponding node for the items you want to consolidate.
To expand or collapse the node double click on the corresponding node.
Select the node for the items you want to consolidate and press the button Consolidate to generate the report.
You will see this consolidation result: