How to do it...

To demonstrate how relationships work, perform the following steps:

1. On a Report page, create a Table visualization and place the Month column from the R07_TableB table as a field in the visual.
2. While that visualization is still selected, place the R07_CountOfDays measure in the visual.
3. Create a second Table visual and place the Month column from the R07_TableA table as a field in the visual.
4. With this second visualization still selected, drag the Date column from the R07_TableA table into the visual and change its default aggregation to Count.

The first Table visualization lists the months in alphabetical order, while the R07_CountOfDays measure displays the number of days in each month. The second Table visualization also lists the months in alphabetical order and the second column displays 1 for all rows.