Here we are going to convert the Pivot table from the list of Incident list generated based on query present in Script Include.

(Note: to get the Script Include and UI Page code click here --> https://bit.ly/2SF68iN)

Follow the Steps to develop Pivot Table in UI Page:

1. Create Script Include to get the records

-> Navigate to .

-> Click New to create New Script Include

-> Name: PivotReportValues

-> Client callable: true

-> Script:

(Note: to get the Script Include and UI Page code click here --> https://bit.ly/2SF68iN)

2. Create Script Include to get the records

-> Navigate to .

-> Name: Pivot Table

-> HTML:

(Note: to get the Script Include and UI Page code click here --> https://bit.ly/2SF68iN)

Client Script:

(Note: to get the Script Include and UI Page code click here --> https://bit.ly/2SF68iN)

3. UI Page Output:

UI Page – Pivot table for other tables:

In Script Include modify the table name and query then push the 3 values into the array so that we can generate Pivot Table from the other tables.