Hi all,
i have a problem with a pivotgrid, as the title say i would like to add some filter conditions to my grid, below some lines of my code:
this.radPivotGrid1.DataSource = LINQToDataTable(query);
this.radPivotFieldList1.AssociatedPivotGrid = this.radPivotGrid1;
this.radPivotGrid1.RowGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "STATUS", GroupComparer = new GrandTotalComparer() });
this.radPivotGrid1.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "SOMETHING", GroupComparer = new GrandTotalComparer() });
this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "SOMETHING_ELSE", AggregateFunction = AggregateFunctions.Count });
this.radPivotGrid1.AllowGroupFiltering = true;
PropertyGroupDescriptionBase description = (PropertyGroupDescriptionBase)this.radPivotGrid1.RowGroupDescriptions[0]; //STATUS
LabelGroupFilter filter = new LabelGroupFilter();
TextCondition condition = new TextCondition();
condition.Comparison = Telerik.Pivot.Core.Filtering.TextComparison.DoesNotContain;
condition.Pattern = "SELLED"; <-------------- here i would like to insert more than one condition
filter.Condition = condition;
description.GroupFilter = filter;
as you can read in the comment i would like to say, for example: "Display only if my STATUS is not "SELLED" or "LOST"
There is a way to do it?
thank you very much
Andrea