You need to create a % of total (by region) calculation by customer in you aggregate storage database for Net_Revenue

You have the following customer dimensions;
You need to create a % of total (by region) calculation by customer in you aggregate storage
database for Net_Revenue. Select the best syntax for member formula so that the % Total
calculation works at all levels of customer dimension.

You have the following customer dimensions;
You need to create a % of total (by region) calculation by customer in you aggregate storage
database for Net_Revenue. Select the best syntax for member formula so that the % Total
calculation works at all levels of customer dimension.

A.
(Net_Revenue]) / (Parent. [Net_Revenue])

B.
(customer.CurrentMember, [Net_Revenue]) / (customer. CurrentMember,Parent,
[Net_Revenue]);

C.
(customer.CurrentMember, [Net_Revenue]) / (customer. CurrentMember,Parent,
[Net_Revenue])

D.
(customer.CurrentMember, [Net_Revenue]) / (customer. [Net_Revenue]);

E.
(customer.CurrentMember, [Net_Revenue]) / (customer. [Net_Revenue], Products,
YearTotal);



Leave a Reply 1

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