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
