Sometimes the user may wish to reorganise and summarise data in a stream set to get a desired report. The pivot view functionality allows the user to use a stream view attribute's values as the rows against which all other data is reported.

Example 1: Basic Pivot View

1. Open the stream configuration.
2. Go to the Views tab.
3. Create a new view. Choose the 'Pivot' option.
4. Give the View a name. In this example the view is named Demo Pivot
5. Leave the Pivot Column Source as 'View Data'.
6. In the View Attribute pane, insert the attributes you require

In our case we have the attributes already inserted, you can modify the role of an attribute in the pivot view simply by double clicking on an attribute and the following will appear :

In this newly opened View Attribute Configuration Panel, one can modify the details of that attribute, namely one can modify the role it has in that Pivot, the way it aggregates and more importantly the way the Label is used, as it can be used as an Expression, which I will explain further on, in the example.