Graded color formatting

[chaitanya]

Hi, 

How do i apply a graded color formatting in pivotgrid control.? (This functionality in present in excel)

[Dineshraj Kumar]

Hi Chaitanya,   

Thank you for contacting Syncfusion Support,  

And we have checked your requirement – ”To apply a graded color formatting in PivotGrid” and it can be achieved by setting the Conditional Formats. 

Please refer to the below code sample: 
#MainWindow.xaml 

<syncfusion:PivotGridControl.ConditionalFormats> 
<syncfusion:PivotGridDataConditionalFormat Name="C1"> 
<syncfusion:PivotGridDataConditionalFormat.CellStyle> 
<syncfusion:PivotGridCellStyle Background="Red" FontFamily="Segoe UI" FontSize="12"/> 
</syncfusion:PivotGridDataConditionalFormat.CellStyle> 
<syncfusion:PivotGridDataConditionalFormat.Conditions> 
<syncfusion:PivotGridDataCondition ConditionType="LessThan" Value="300000" SummaryElement="Amount" PredicateType="And"/> 
</syncfusion:PivotGridDataConditionalFormat.Conditions> 
</syncfusion:PivotGridDataConditionalFormat> 

<syncfusion:PivotGridDataConditionalFormat Name="C1"> 
<syncfusion:PivotGridDataConditionalFormat.CellStyle> 
<syncfusion:PivotGridCellStyle Background="Yellow" FontFamily="Segoe UI" FontSize="12"/> 
</syncfusion:PivotGridDataConditionalFormat.CellStyle> 
<syncfusion:PivotGridDataConditionalFormat.Conditions> 
<syncfusion:PivotGridDataCondition ConditionType="GreaterThan" Value="3000000" SummaryElement="Amount" PredicateType="And"/> 
<syncfusion:PivotGridDataCondition ConditionType="LessThan" Value="6000000" SummaryElement="Amount" PredicateType="And"/> 
</syncfusion:PivotGridDataConditionalFormat.Conditions> 
</syncfusion:PivotGridDataConditionalFormat> 

</syncfusion:PivotGridControl.ConditionalFormats> 


Please find our working sample from the following location: 
http://www.syncfusion.com/downloads/support/forum/136988/ze/PivotGrid_ConditionalFormats-1952557767 

Regards, 
Dineshraj K.