The P04_14.xlsx file contains the Contoso Data Model discussed in Example 4.4, but without any calculated columns,
Question:
The P04_14.xlsx file contains the Contoso Data Model discussed in Example 4.4, but without any calculated columns, measures, or hierarchies. The question here is whether you can have two different hierarchies in the same table:
a. In the Stores table, create a hierarchy called Store Location 1, using the fields RegionCountryName and StateProvinceName from the Geography table.
b. In the Stores table, try to create a second hierarchy called Store Location 2, using the fields Continent, RegionCountryName, and CityName. Are you allowed to do so?
c. Create two pivot tables on separate worksheets, one summarizing SalesAmount by the first hierarchy and the other summarizing SalesAmount by the second hierarchy (if it’s allowed).
Step by Step Answer:
Business Analytics Data Analysis And Decision Making
ISBN: 9780357109953
7th Edition
Authors: S. Christian Albright, Wayne L. Winston