Enable Workgroup products to perform a pivot calculation using SQL

Currently it is possible to perform an SQL query on 2 or more data fields

e.g., SELECT SUM(length) AS "Pipe Length (m)" GROUP BY pipe_class AS "Pipe Class", user_text_9 AS "Pipe Size Category"

This will produce a long list of grouped combinations of each pipe class and Pipe Size Category. This long list is not as easy to read or interpret compared to how Excel is able to create a matrix comprising 2 axis, with grouped Pipe Class on one axis and Pipe Size Category on the other.

This is how the report looks in InfoAsset Manager
and this is how the report looks like in Excel using Pivot Table