Define Filtering

You can define data filtering for the report via XML configuration.

You can filter data both on rows and on columns in the Pivot Table report. Filters are additive ('AND' filters), and can be applied to any field from rows or columns. Each additional filter reduces the subset of data. Each <hierarchy> tag can have additional <filter> block which includes all the members of the field which would be included into report.

<axis name="rows">
  <hierarchy>
    <dimensionName>[Color]</dimensionName>
    <hierarchyName>[Color].[Color]</hierarchyName>
    <filter>
      <member>[Color].[Color].[red]</member>
      <member>[Color].[Color].[green]</member>
    </filter>
  </hierarchy>
</axis>