Pivot Table View Documentation

Ultimate

The Pivot Table view visualizes Business objects in a Pivot Table where the columns/rows are the options of a Business Model property.

Settings:

• Rows: Business Model property which options will be used as rows
• Columns: Business Model property which options will be used as columns
• Values: Business Model property or type Number, if selected the table will show this property instead of the Business objects
• Show empty rows/columns, "Start" icon: If selected the rows/columns without any Business objects will not be shown

Notes:

• If you select a Date property for your rows/columns you have to filter by a range in order to see its options in the table
• If you select a User property for your rows/columns only the first 100 Users/Groups or both will be shown
• If you select a Many-To-One or One-To-Many property for your rows/columns only the first 100 Business objects corresponding to the property Business Model or both will be shown