Building Reports Using Foresight Excel Add-In > Building Report Using Add-In > Working with Report from Repository > Working with Analytical Queries (OLAP) > Working with Data Table > Data Transformation
Data transformation enables the user to present table data in various formats.
To transform selected data:
Click the 
Transform Data button in the View group of the Table ribbon tab.
Select the transformation option for rows or columns in the drop-down menu of the button:
Growth, %. Value change is displayed as percentage.
Growth rate, %. Growth rate is displayed.
Change. Difference between the current and the previous values is displayed.
Share, %. Share of the cell value from the sum of entire row or column values is displayed.
To cancel data transformation, click the Transform Data button.
Table source data:
Data after the Growth by Rows, % transformation:
See also:
