Exercise 20

Repeat the steps in the recipe to create a metric at Country level using a copy of Sum SalesAmount from FactInternetSales. Then create another metric with the formula:

  ([Sum SalesAmount from FactInternetSales] / [Sum SalesAmount from FactInternetSales (Country Level)])

Use those metrics in a report with the Country and StateProvince attributes.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset