Hi I'm new here so sorry about the unconventional formatting. I have a item table with different coloured paints. I have created a unique list of colours and I am trying to create a relationship between the UniqueColourList and all 8 colours cloumns on the item table so that when expanded shows only the item numbers that has that colour. I've gotten it to "work" by creating a relationship with all 8 colours (some sorta crazy 1-to-many x 8).
Practical use would be to expand the pivot table at blue and see all the Items that require blue so that forecasting can be done on how much blue paint to order & is require for exisitng orders etc.
I was wondering if there is some better method to get a cleaner result without powerpivot and with powerpivot?