Hi.
Please help me with following problem...
I have following pivot-columns:
[A] [B] [C]
[A] and [B] .. are some double values
[C] is percentage (([A] - [B])/[A])
Definition in xaml:
<syncfusion:PivotGridControl.AllowedFields>
<syncfusion:FieldInfo Name="C" Expression="([A] - [B]) / [A]" FieldType="Expression" />
</syncfusion:PivotGridControl.AllowedFields>
<syncfusion:PivotGridControl.PivotCalculations>
<syncfusion:PivotComputationInfo FieldHeader="A" FieldName="A" SummaryType="DecimalTotalSum"/>
<syncfusion:PivotComputationInfo FieldHeader="B" FieldName="B" SummaryType="DecimalTotalSum"/>
<syncfusion:PivotComputationInfo FieldHeader="C"
FieldName="C"
SummaryType="DecimalTotalSum"
Format="P"/>
</syncfusion:PivotGridControl.PivotCalculations>
Problem is, that the total value of [C] is summary of its pivot values, not the value ([TOTAL_A]-[TOTAL_B])/[TOTAL_A].
Thanks.
Regards,
Juraj