How to use the rollup property

This section covers the rollup database property and how you can use it to get calculations from another database and use that value in various views, as well as shows us how rollups can be used to change the information you see.

The reason this property is so powerful is that it saves navigation time, helps create clear overviews, and calculates the value and numbers you are looking for.

Note

As mentioned previously, you cannot use a rollup property without a relation property in the database.

Using the same database as the previous chapter, we are going to add a rollup property showing information across databases. Figure 7.8 shows selecting the relation property in the rollup configuration window. This drop-down menu will only show relation properties that are in the same database you are creating the rollup in:

Figure 7.8 – Selecting the relation property for the rollup configuration

Once the relationship...