What is a Data Map Report?

A data map report breaks down end topics by grouped topics. 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 Data Map

To view a data map report, you must first create the data map. Refer to the What is a Data map and how do I create a Data Map? article to learn how to create the data map. Here is the resulting data map of the Sales by Country.xlsx example file. expanded so that you can see one of the end tables.

Select Data Map Report

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

Select Data 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 - a set of tables - on a new worksheet.

View the summary data

The top of the report shows the rollup calculations. In this case, there is a separate table for each year.

View the summary data

View detailed calculations

Any of the hyperlinks in the summary report takes you to a detailed table such as the following for Hair Care in Asia in 2011. The link at the top right takes you back to the summary section.

View detailed calculations

View formulas

Each of the cells in the report contains a formula. The meaning of this formula isn't important. The important part is that the formula retains a link to the underlying data set. Therefore, if the data change, the data map and the data map report update automatically.

View formulas