2014Q3 controls.
Field definitions
KG = amount of a certain material for one company
TotalKG = amount of a certain material for all companies
The % of Total column is working properly for detail rows and subtotal rows. However for the grand total row I get 6.25%, which is 100 / 16 (the number of companies) / 100. I am expecting to see 100% as the Grand Total of Sum of KG equals the total of all materials for all companies. Bug or something else?
Field definitions
<
Fields
>
<
telerik:PivotGridRowField
Caption
=
"Company Name"
DataField
=
"sEntityName"
UniqueName
=
"sEntityName"
>
</
telerik:PivotGridRowField
>
<
telerik:PivotGridRowField
Caption
=
"Material"
DataField
=
"Material"
UniqueName
=
"Material"
>
</
telerik:PivotGridRowField
>
<
telerik:PivotGridColumnField
Caption
=
"Year"
DataField
=
"SubmissionYear"
UniqueName
=
"SubmissionYear"
>
</
telerik:PivotGridColumnField
>
<
telerik:PivotGridColumnField
Caption
=
"Period"
DataField
=
"Period"
UniqueName
=
"Period"
>
</
telerik:PivotGridColumnField
>
<
telerik:PivotGridAggregateField
Caption
=
"KG"
DataField
=
"KG"
GrandTotalAggregateFormatString
=
"{0:###,###.00}"
UniqueName
=
"KG"
CellStyle-CssClass
=
"ptRJ"
TotalFormatString
=
"{0:###,###.00}"
DataFormatString
=
"{0:###,###.00}"
>
</
telerik:PivotGridAggregateField
>
<
telerik:PivotGridAggregateField
DataField
=
"% of Total"
CalculationDataFields
=
"KG,TotalKG"
CalculationExpression
=
"{0}/{1}"
DataFormatString
=
"{0:p}"
>
</
telerik:PivotGridAggregateField
>
</
Fields
>
KG = amount of a certain material for one company
TotalKG = amount of a certain material for all companies
The % of Total column is working properly for detail rows and subtotal rows. However for the grand total row I get 6.25%, which is 100 / 16 (the number of companies) / 100. I am expecting to see 100% as the Grand Total of Sum of KG equals the total of all materials for all companies. Bug or something else?