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).