How to create custom Hierarchies?

[Skeptical]

Good evening all,

I am trying to create some custom hierarchies in the following situation.


Sales Manager Patrick is responsible for Home appliances division and he has Cookers, Stoves, Chimneys in his product range.

Sales Manager Kevin is responsible for Furniture division and he has Cots, Chairs, Tables in his product range.

Sales Manager Nicolas is responsible for Electronics division and he has Laptops, Desktops, Mobiles in his product range.


Question is: I know how to create natural hierarchies like Continent, Country, City OR Year, Month, Day etc

But I have been struggling with creating the above hierarchies. Is there any direct way to create the same?

I want to see Division name as my Hierarchy name and under the same I want to see all the products related to that particular division. Is it possible in PowerPivot, How???


Thanks in advance
Skeptical

 

[Matt Allington]

It seems in this case that there is a direct 1:1 relationship between products and sales managers. So why not just add extra columns to your product table for division, sales manager etc.