Posted 21 August 2020, 7:32 am EST
Hi,
Yes, you can have filter the olap data with default filters. For this, after adding filter field to FilterFields collection, you need to access field.Filter and define its ShowValues (for numeric) or Condition1/Condition2, Operator and Parameter properties(for conditional filters), as follows:
Access the Filter:
var field = olap.Fields["Category"]; olap.FilterFields.Add(field); var filter = field.Filter;
Numeric Filter:
filter.Clear(); filter.ShowValues = new string[]{ "Beverages"};
Conditional Filter:```
filter.Clear();
filter.Condition1.Operator = C1.Olap.ConditionOperator.GreaterThanOrEqualTo;
filter.Condition1.Parameter = min;
filter.Condition2.Operator = C1.Olap.ConditionOperator.LessThanOrEqualTo;
filter.Condition2.Parameter = max;
Regards,