How would you accomplish this?

A customer needs to have a calculation done prior to aggregating the data. How would you
accomplish this?

A customer needs to have a calculation done prior to aggregating the data. How would you
accomplish this?

A.
By creating a derived measure by using the Logical Columns available

B.
By creating a derived measure in the Column Mapping dialog box byusing the physical
tablecolumns.

C.
By creating a derived measure by using LogicColumnsavailable andchanging
theaggregationtype

D.
By creating a derived metricby using the Expression Builder

E.
By creatinga derived metricby using the Calculation Wizard

Explanation:

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Leo Yu

Leo Yu

B), then change the aggregate type within the content tab.

Reply

Leosiu

Leosiu

B.
However, if the calculated measure is derived from the product of two PHYSICAL columns, then the multiplication will be executed first, and then the aggregation after.

Reply