Tell me more about possible calculations in a Linked Map
A linked map can not only show the relationships between topics, but it can also show rollup calculations.
Data set for the linked map
This data set lists cereal categories (through row 14) and individual cereal products (from row 15 down). The rollup calculations will apply to the categories. Because these categories don't have values for columns C to H, BigPicture requires asterisks in these columns if rollups are desired.
Specify relationships
You first indicate how topics are linked (i.e., related).
Specify desired rollup calculations
In this example, it makes sense to request averages for the four numeric columns. For example, the map will show the average price per ounce for all cereal products in the data set and for all Kelloggs products in the data set.
NOTE: The Calc Depth for Linked Maps will automatically be set to All Below.
Specify types of summaries
Under Calc Type, you can specify sums (totals), averages, minimums, or maximums.
Specify display type
Under Display In, you can specify a Topic Note or a Topic Label. A Topic Note appears as a note below the topic with a summation sign, and a Topic Label includes the summary information in the topic's label.
View rollup results
Here is a sample of the category topics, where each of the average rollups is shown as a Topic Label and the Min and Max for sugar is shown as a Topic Note.
