You create a PerformancePoint Add-in for Excel report. Your model has a dimension named Products. The Products dimension contains two member sets named Color and ProductCategory. You add a matrix to the report. The matrix displays the number of products in the ProductCategory member set. You need to ensure that the matrix displays the number of products in the ProductCategory member set only if the Color member has a value of either Red or Blue. What should you do?
A.
Add the Color member to the matrix row. Select the members Red, Blue.
B.
Add the Color member to the matrix column. Select the members Red, Blue.
C.
Add the Color member to the matrix filter. Set the Default Selected Members property of the matrix filter to Red, Blue.
D.
Add ProductCategory to the matrix filter. Set the Default Selected Members property of the matrix filter to Red, Blue.