Hi,
I have two tables Assortiment and Data with association on item_key. How to get Result table as below with filter on assort_category? What I need to change - data model or measure calculation sum(sales)? There is millions rows in both tables, so i need to think for performance too.
Hi,
there is not perfect key, which means that some values cannot be paired with values from second table. And that is the reaso why you see what you see.
I don't know the logics behind your data model so it is difficult to tell what to change. Could you try to explain in more details?
