Two dimensions where not all cross joined combinations are needed
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.
Any suggestions? TIA