Percentage summary display types are designed to show cell values as a percentage of the Total and Grand Total values in data cells.

Percent of Column

The percentage of the Column Total value is displayed in a cell.

PercentOfColumn

Cell values are calculated as follows:

Column	Calculation	Description
Chai – September – PercentOfColumn	0.4935 = 518.4/ 1050.4	518.4 is the actual sum calculated against the Product Sales field for the Chai – September cell, and 1050.4 is the Total value calculated for this column (Beverages – September).
Beverages Total – September – PercentOfColumn	0.814 = 1050.4/ 1290.4	1050.4 is the Total value calculated for the Beverages – September column against the Product Sales field, and 1290.4 is the Grand Total value calculated for this column (September).

Percent of Column Grand Total

The percentage of the Column Grand Total value is displayed in a cell.

PercentOfColumnGrandTotal

For instance, the Chai – September – PercentOfColumnGrandTotal cell value is calculated as follows:

0.4017 = 518.4/1290.4

518.4 is the actual sum calculated against the Product Sales field for the Chai – September cell, and 1290.4 is the Grand Total value calculated for this column (September).

Percent of Row

The percentage of the Row Total value is displayed in a cell.

PercentOfRow

Cell values are calculated as follows:

Row	Calculation	Description
Beverages – August 1994 – PercentOfRow	0.3228 = 2226.9/ 6898.58	2226.9 is the actual sum calculated against the Product Sales field for the Beverages – August 1994 cell, and 6898.58 is the Total value calculated for this row (Beverages – 1994 Total).
Beverages – 1994 Total – PercentOfRow	0.3377 = 6898.58/ 20426.1	6898.58 is the Total value calculated for the Beverages – 1994 row against the Product Sales field, and 20426.1 is the Grand Total value calculated for this row (Beverages).

Percent of Row Grand Total

The percentage of the Row Grand Total value is displayed in a cell.

PercentOfRowGrandTotal

For instance, the Beverages – August 1994 – PercentOfRowGrandTotal cell value is calculated as follows:

0.109 = 2226.9/20426.1

2226.9 is the actual sum calculated against the Product Sales field for the Beverages – August 1994 cell, and 20426.1 is the Grand Total value calculated for this row (Beverages).

Percent of Grand Total

The percentage of the Grand Total value is displayed in a cell.

PercentOfGrandTotal

For instance, the Chai – September – PercentOfGrandTotal cell value is calculated as follows:

0.1595 = 518.4/3249.6