You can now Pivot based on a Mashup Field.

1. Click on 'Configuration Tool'

Click on 'Configuration Tool'

2. Click the 'View Type' Dropdown

Click the 'View Type' Dropdown

3. Select 'Pivot'

Select 'Pivot'

4. Select your options.

1) These are the fields that you wish to keep as columns.

2) These are the fields you wish to pivot.

3) This is where you choose what is shown under the pivoted fields and how it's aggregated.

4) Click Load.

Select your options.

5. Your table will now be shown in Pivot View

Your table will now be shown in Pivot View