I feel like you're going to have to do table calculations for this, but I don't see how that would require you to have all your product categories and sub-categories in the same view (I guess it's tough to tell from the sample).
Here's how a table calc will achieve it;
> Drag Industry Week onto the detail button on the marks card
> Create a calculated field with the formula INDEX() or add the formula directly onto the columns shelf.
> Edit the table calculation and set it to compute using specific dimensions. Select Title and Industry Week Value and make sure they are in that order. 'At the level' = deepest and restarting every = 'Title'
Thanks Tom. That gets me a slightly garbled viz, but I'll keep poking it to find out how I'm mucking it up.
Is there a way of getting the table headings as well? Week 1, Week 8, Week 52? We frequently report like this and it would be handy to be able to dashboard it.
Make sure you set the pill to be discrete, not continuous.
You could create a calculated field like "Week " + STR(INDEX()) and set it up the same way I described above
Thank you Tom