What is a Data Map Report?

A data map breaks down end topic by grouped topics. The map shows the results of the calculations graphically. You might also want to see the results of the calculations in tables in Excel. This allows you to use map calculations in other Excel formulas.

Start with a data set

The data set you see here is from the Data Map - Sales By Country example spreadsheet that comes with BigPicture.

Create a data map

Click the Data Map button to bring up the Data Map dialog box.

Create a data map

Select the grouped topics

Here, the breakdowns will be by year, then by region, and then by (product) category.

Select the grouped topics

Select the end topics

Here the end topics will be broken down by country and/or product, and they will show the sum of units sold and the sum of profit. Each of these calculations, along with counts of data rows, will be rolled up to the grouped topics. (You can also select pictures, markers, and filters, and you can choose the display settings, although these aren't as relevant to the data map report.)

Select the end topics

View the data map

Here is the resulting data map, 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