In this article
Click on a data cell in the aggregated table to open a Cell Information window. This window displays information related to cell location, calculation rule, values used during the evaluation (in some cases) and report/page/table options that affect the final value displayed .
Figure 1 - Example of the Cell Information window for cell "BMW-Female" in the table above
Right-click on a data cell in the aggregated table to open a context menu . This menu allows quick access to some of the most commonly used functionality for the data cells.
Figure 2 - The context menu for a cell in an aggregated table
The menu commands are:
- Save - saves any changes to the table.
- Refresh - updates the table to include any changes but does not save those changes.
- Conditional Formatting - opens the conditional formatting functionality.
- Cell Info - opens the Cell Information window - see above.
- Add to Compare - holds the current cell information ready to compare it with another cell's information (go to Comparing Two Cells for more information).
- Compare - [only available if another cell has previously been "Added" - see above] compares the current cell information with the cell information previously added. Common properties are displayed, with any differences highlighted in red (go to Comparing Two Cells for more information).
- Table properties - opens the table's Properties page (go to Table Property Sheet for more information).
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.