What is a Linked Map Report?
A linked map report breaks down all of your rollup information in a tabular format. The map shows the results of the calculations graphically, while the report shows the results of the calculations in tables in Excel. This allows you to use map calculations in other Excel formulas.
Create and View the Linked Map
To view a linked map report, you must first create the linked map. Refer to the What is a Linked map and how do I create a Linked Map? article to learn how to create the linked map. Here is the resulting linked map of the Linked Map - Cereals.xlsx example file expanded so that you can see the end topics of Post brand cereal.
Select Linked Map Report
View the data map report
This creates a report on a new worksheet. The report shows the rollup calculations (See #1) in addition to the information for each type of cereal. If you click on the "group" linked (i.e. Kellogg's - See #2) it will expand/collapse the individual cereals that contribute to that group.