Category / Section
How to add filter expression in PivotReport?
1 min read
This KB illustrates that how to add filter expression in PivotRepoort.
Solution:
You can filter any Pivot Item with its values using the “Filter Expression” option in PivotReport.
In the below code sample, the Pivot Item “Date” is filtered by its values “FY 2008” and “FY 2009”. For “DimensionName” property, we need to provide the name of the Pivot Item and for “Expression” property, we need to provide the values along with the dimension name in the following format – “Dimension Name = Member1 Name || Member2 Name || ….”.
C#
PivotReport pivotSetting = new PivotReport();
//Other Codes
pivotSetting.Filters.Add(new FilterExpression { DimensionName = "Date", Expression = "Date = FY 2008 || Date = FY 2009"});
VB
Dim pivotSetting As New PivotReport()
'Other Codes
pivotSetting.Filters.Add(New FilterExpression() With {
Key .DimensionName = "Date",
Key .Expression = "Date = FY 2008 || Date = FY 2009"
})
