A business analyst must create a horizontal bar chart to identify the top Sales Reps, Customer Segment Description, and Customer City.
✑ Users must be able to analyze the data for one field at a time
✑ The chart should show the unique number of customers for each dimension being analyzed
The dimensions and measures created must be re-used on other charts
Which steps should the business analyst perform to configure the chart correctly?
A.
✑ Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions
✑ Create a master item measure using Count(Distinct[Customer Number]) and add it to the chart
✑ Change the chart presentation to Horizontal and sort it by the measure
B.
✑ Create a cyclic dimension as a master item using all three dimensions and add it to the chart
✑ Create a master item measure using Count(Total[Customer Number]) and add it to the chart
✑ Change the chart presentation to Horizontal and sort it by the measure
C.
✑ Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions
✑ Create a master item measure using Count(Total[Customer Number]) and add it to the chart
✑ Change the chart presentation to Horizontal and sort it by the measure
D.
✑ Create all three dimensions as master items and add to the bar chart
✑ Create a master item measure using Count(Distinct[Customer Number]) and add it to the chart
✑ Change the chart presentation to Horizontal and sort it by the first dimension