Pivot tables are a type of metric. They are a convenient method to summarise how many entries in a set of data have a particular combination of values for two attributes of interest.
When a pivot table is published in a WorkBench tab, each cell contains a hyperlink. If you click on a hyperlink, the items from the database that have the corresponding combination of values are shown in the view that is defined as part of the pivot table. There are also hyperlinks for each row, for each column, and for the entire pivot table. Selecting these hyperlinks will display database items for the row category value, for the column category value, and for all items in the query, respectively. Such pivot tables can be referenced from the project’s phase / process hierarchy and can be embedded inside a report, as for any other metric. This capability is a very powerful management information and data analysis tool, both when published externally from Cradle and, particularly, when used inside the Cradle environment.
