Hi,
I have a PivotGrid, which has the following layout:
<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" AllowFiltering="false" RowGroupsDefaultExpanded="false" RowTableLayout="Compact"
ShowColumnHeaderZone="false" ShowDataHeaderZone="false" ShowFilterHeaderZone="false" ShowRowHeaderZone="false"
OnNeedDataSource="RadPivotGrid1_NeedDataSource" OnCellDataBound="RadPivotGrid1_CellDataBound">
<ClientSettings EnableFieldsDragDrop="false">
<Scrolling AllowVerticalScroll="false"></Scrolling>
</ClientSettings>
<TotalsSettings RowsSubTotalsPosition="Last" ColumnsSubTotalsPosition="None" />
<Fields>
<telerik:PivotGridRowField DataField="Customer" ZoneIndex="0">
</telerik:PivotGridRowField>
<telerik:PivotGridRowField DataField="Contract" ZoneIndex="1">
</telerik:PivotGridRowField>
<telerik:PivotGridColumnField DataField="Quater">
</telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="SalesTax">
</telerik:PivotGridColumnField>
<telerik:PivotGridAggregateField DataField="Amount" Aggregate="Sum">
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="Changed" Aggregate="Sum" IsHidden="true">
</telerik:PivotGridAggregateField>
</Fields>
</telerik:RadPivotGrid>
The AggregateField "Amount" is type of decimal and "Changed" is type of bool.
My aim is to format the Field "Amount" with an ending "*" or a special color, if the Field "Changed" is true. How could I achieve this?
Thanks,
Jan-Bernd