Navigation:  Quick Start Tutorials > Using Reports > Using Reports (Pivot) >

Variation, Rank and Contribution

Previous pageReturn to chapter overviewNext page

Adding Variation, Rank and Contribution to Pivot Reports

The add column input in any pivot report has ‘Summery Display Type’ selection list.

 

Calculation

% of Column & % of Column Grand Total

It is used to calculate the contribution of a field in percentage, by considering the total of column

Example:  You might want to find the contribution of a group of item with respect to total sale.

The contribution of group is calculated as (Sale Value of the Group)  * 100 / (Total sale value of the month)

 

% of Grand Total

It is used to calculate the contribution of a field in percentage, by considering the grand total of the report.

Example: You might want to find the month wise sale figure for group of items. The contribution of each group for every month is calculated as

(Sale Value of the Group) * 100 / (Grand Total of Sale Value)

 

% of Row & % of Row Grand Total

It is used to calculate the contribution of a field in percentage, by considering the total of row.

Example: You might want to find month wise sale figure for group of items. For each group's contribution for every month wise is calculated as

(Sale Value of the Group) *100 / (Total Sale Value of the Row)

 

Context Menu in Pivot Report

 

Column Total: Works as a toggle button. It turn column total on or off
Row Total: Works as a toggle button. It turn row total on or off