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

Starting from the worksheet with the map, select Create Report from the Linked Map dropdown on the BigPicture ribbon

Select Linked Map Report

Save as pdf?

Besides creating the report, you have the option of saving it as a pdf file.

Save as pdf?

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.