Comparing Two Cells

Assume you have two tables which look identical but show slightly different results .as shown below.

Figure 1 - Two tables which look identical but show slightly different results

To discover what the differences between the two tables are by checking the cell and table properties .- could be quite time consuming.

Figure 2 - Checking the cell properties for one of the cells in the table

You can however compare cells in the two tables, and the differences will be highlighted. To do this:

1. Go to the aggregated table that includes one of the cells that you wish to compare.
2. Right-click on the data cell to open the context menu and select Add to Compare .



Figure 3 - Selecting Add to Compare

The cell information is held in memory.

3. Go to the table containing the other cell that you wish to compare with the first.
4. Right-click on the data cell to open the context menu
5. Click Compare .

Figure 4 - In the second table, selecting Compare

The Cell Information window opens with two columns of information .

Figure 5 - The cell properties compared

Only properties that are common for both cells are displayed, with any differences highlighted in red for the second cell selected.

Note: Only two cells can be compared against each other at one time. Comparisons are only possible between tables within the same report - you cannot compare tables in two different reports.