Date Published: February 2015
Data in rows can be moved to columns to group data for purposes of analysis or to organize data in different ways. This is typically more useful when moving data that only includes a few categories rather than lots of categories.
Below is an example using Measure Type data.
The screen below shows the generated Perf Rept01 report Measure Type data highlighted.
To move the Measure Type data to Columns, users can use the right mouse button to select Move and then To Columns (shown below) or use alternatively, can use the left mouse button to drag the item to above the data columns.
Once the Move is complete, each Measure Type will now show as a new column, with data for the Activities grouped accordingly.