What are the advanced summarizing options?
When creating pivots, you can choose how to summarize data i.e., by Sum, Max, Min, Average or by Count in a column, depending on its data type. Click here to learn more.
Apart from these, Zerion Reports also provides advanced summarizing options, which allows you to summarize data values in a column based on other values in the column.
How do I apply these advanced options?
With your Pivot view loaded, click the Edit Design button.
From the drop-down menu choose from the applicable functions based on the column data type and choose how you want to show the data.
Select the field to apply to the function and click Apply.
Select Click Here to Generate Pivot.
You'll see the function now applied.
The following are the functions available for advanced summarization:
|% of Row||Displays data as a percentage of the total for each row.|
|% of Column||Displays data as a percentage of the total for each column|
|% of Total||Displays values as a percentage of the grand total of all the data in the report.|
|Running Total||Displays data in successive cells of the report as a running total. You must select the base field based on which you want to show the items in a running total.|
|Difference From||Displays the data in each cell as the difference from the value in the previous cell, based on the base field provided.|
|% of||Displays the data in each cell as a percentage of the value in the previous cell, based on the base field provided.|
|% of Difference From||Displays the data in each cell as a percentage of differences from the value in the previous cell, based on the base field provided.|