The following expression is used in a crosstab report: filter([sales_and_marketing]. [Product brand]. [Product brand].[Product brand type],[Revenue] <100000000). There are 26 product brand types in the OLAP data source.
Why does the report only return 11 product brand type rows?
A. A relational function was used to filter on the measure values, not the members.
B. A dimensional function was used to filter on each column.
C. A relational function was used to filter on the members, not the measure values.
D. A dimensional function was used to filter on the total of the opposite edge.