Forum Discussion
Always include certain rows (across multiple fact tables) based on a single (selected) condition
I am attempting a new modelling structure to negate my current method of repeating (always to be included) rows in my dataset for every "Design Option", i.e. where the red-highlighted items ar...
picking this up again (got distracted with other things) and thinking I perhaps need to reframe my question, so as per below:
I have the blue table - and want to be able to get to the green and orange tables - where the row items 1,2 & 3 are summed with items of matching criteria (here only [ZONE] but in future additional others)
...so if/when seen in a column visual, the (yellow) values of -- wouldn't be seperate, but repeated/included in the columns of Aa,Ab & Ac:
any and all help much appreciated! 🤞