A.Aggregated Calculated Columns

B.Date Options

C.Runtime Filters

D.Calculated Columns

A.Set Color to Pay Grade

B.Set Color to Gender

C.Set Dimensions to Gender

D.Set Measures to EOP Headcount

E.Set Dimensions to Pay Grade

A.Change the metric calculation from Count to Count distinct.

B.Remove the column that wouldgenerate multiple entries per metric.

C.Remove the category assignment field.

D.Configure a filter to remove the duplicate column.

A.Table Structure: Cross-tab

B.Row: Count

C.Table Structure: Aggregated List

D.Column: Count

A.OR

B.AND

C.NOT