Articles in this section
Category / Section

How to add conditional formats to the grid in OlapClient

1 min read

We can add the conditional formats to the OlapGrid in OlapClient. This can be achieved by following code snippet.

C#

 
   void olapClient_Loaded(object sender, System.Windows.RoutedEventArgs e)
        {
            if (this.olapClient.OlapGrid == null)
 
            this.olapClient.ApplyTemplate();
 
            if (this.olapClient.OlapGrid != null)
            {
 
                OlapGridDataConditionalFormat condn1 = new Syncfusion.Silverlight.Grid.Olap.OlapGridDataConditionalFormat();
 
                condn1.Conditions.Add(new OlapGridDataCondition() { ConditionType = OlapGridDataConditionType.GreaterThan, Value = 50000, PredicateType = Syncfusion.Windows.Data.PredicateType.Or, MeasureElement = "Internet Sales Amount" });
 
 
                condn1.CellStyle = new OlapGridCellStyle() { Background = (Brush)new SolidColorBrush(Colors.Red) };
 
                this.olapClient.OlapGrid.ConditionalFormats.Clear();
 
                this.olapClient.OlapGrid.ConditionalFormats.Add(condn1);
 
            }

 

 

Figure: OlapGrid with applied conditional formats in OlapClient

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied