Two dimensions where not all cross joined combinations are needed

Options
GaryPage
GaryPage Member, ALL USERS, Partner Posts: 4 Occasional Contributor
in Enterprise Scale

Hi

 

i have a list of divisions and a list of products. The divisions are defined by customer type and not by product, so not all divisions sell all products, but there is a lot of overlap. We would want to be able to show sales by division, and also sales by product.

 

The easy thing would be to have two unrelated lists, but the issue with that is the vast majority of combinations will always be blank. Also a division FC would want to see only those products relevant for his division, and not some giant list.

 

Illustrative example is below, but there would be a lot more “missing” products.

 

Division A

    Product W

    Product X

    Product Y

 

Division B

    Product X

    Product Z

 

Division C

    Product X

    Product Y

    Product Z

 

Any suggestions? TIA

Tagged:

Comments

  • GaryPage
    GaryPage Member, ALL USERS, Partner Posts: 4 Occasional Contributor

    @rob_marshall @LipChean_Soh Thanks both. 


    I can see how this approach will let me get a hierarchy will only have the required items, and that the numbered list with display names will get around the duplication of names. I am not sure how this will allow me to show a breakdown of sales by product. Even though the products will have the same name, they won't really be the same under the hood will they?

     

    I haven't looked at the 305 training yet, but I will do.

Categories