What are the 'rules' governing how accessories are associated with products?
I think how you define that is going to be key to finding a solution. I sense that Level of Detail calculations might play a role, but really need more detail.
Tableau Online Deployment Advisor
Thanks for looking.
They are all tech products so most accessories are related to just 1 product so in my particular case there is a streaming media box and a tablet.
The accessories being:
Accessory Product Remote Streaming Box Stand Streaming Box Controller Streaming Box & Tablet Cover Tablet Stylus Tablet Charger Tablet
This associations won't change so they will only ever be what is written above with just the controller being the awkward one in that it can be used by both the streaming box and tablet and thus has to have an attach rate calculated upon based on the total sales of both in any given time period.
Was that what you meant?