Quick Pivot (Legacy)
Like the name suggests, Quick Pivot allows you to quickly perform "pivot-table" transform on a report's result dataset.
After running your query, you can pivot the table by selecting the 'quick pivot' option in the report editing page under the SQL Editor panel.
#
How It WorksGiven the following table that stores your pageviews traffic data:
A simple select to get your pageviews by traffic:
will get you something like this:

'Quick Pivot' allows you to instantly generate this, which is a lot easier to consume (and visualize).

#
Usage
A few notes on how it works:
- It uses the last column as the measure values (numbers)
- It uses the second last column as the dimension to be pivoted
- You can have as many remaining columns on the left as you want.
To use, you'll find an option for 'quick pivot' in the report editing page, under Preview panel.
#
Can I still achieve the same thing without 'Quick Pivot'?Yes but. You'll have to write more troublesome SQL queries like this:
And even so, when new traffic source comes, you'll have to modify the report's query to cater for new cases.
#
What's the difference between Quick Pivot (Transform) and Pivot Visualization?Quick Pivot allows you to pre-transform the queried data, and after that you can apply a graph (Line Chart, Column Chart, etc) to it.
Pivot Visualization is a visualization itself based on the data queried.