Pivot tables are a convenient method to summarise how many entries in a set of data have each combination of values for two attributes of interest. For example:

A pivot table can summarise the numbers of requirements with each combination of Responsibility and Status:

This shows:

• There are two requirements with Responsibility = Customer and Status = Agreed with IDs UR-1 and UR-7
• There is one requirement with Responsibility = Developer and Status = Disputed, with ID UR-2

The overall total shown in the bottom-right corner will always equal the number of items being summarised, 10 in this case.

Cradle fully supports pivot tables, which can be defined using any appropriate pair of attributes for all types of information, including all user-defined item types. Pivot tables can be published from Cradle custom web UIs and into the WorkBench non-web UI. Pivot tables can be published to external files in CSV, RTF (for Word and Write) and HTML (for web browsers, Excel and Calc).

In its pivot tables, Cradle includes all of the possible values for the attributes being analysed, and also:

• <Unset>, meaning that the item does not have a value for the attribute
• <Other>, meaning that item’s attribute value is not one of the values currently allowed for the attribute

In Cradle, each non-zero cell in a pivot table is a link to the items that have the corresponding combination of attribute values. You can select such links to open a new tab containing a list of the items with the corresponding combination of attribute values.

You can reference pivot tables in reports and in the phase hierarchy. You can generate them from the c_table command line utility. You can also generate them in documents produced by the Document Publisher tool.

Pivot tables are a type of metric, so a Cradle-MET licence is needed to define, generate and publish them.

1. 3SL Newsletters
2. Newsletter Contents
3. 3SL Website
4. Need Help?
5. Cradle Group on LinkedIn
6. New 3SL Internet Link and ISP
7. Matrices
8. How to Create a Matrix for One Set of Items
9. How to Create a Matrix for Two Sets of Items
10. How to Create a Matrix for Three Sets of Items
11. How to Create a New Project
12. How to Create New Users in a Project
13. Pivot Tables
14. How to Create Pivot Tables
15. How to Link Cradle to Visio Diagrams
16. How to Link Cradle to Visio Symbols
17. Acrobat Compatibility
18. Mixed Office Installations
19. Old Versions of Cradle

Back to this newsletter index.