Hi,
I've managed to make a dynamic ranking with a custom TopN filter, output is a table with brands ranked by TopN filter and the rest is always summed up by a total under "Others". This is because there are several subcategories. So within a subcategory the dynamic filter is working on brand level.
My question: I would like to include in the ranking always certain brands, which might not be present in the selected TopN ranking. I have a dim table with all the Brands connected to the company. So the idea would be:
- TopN filter on ranking by brand within a subcategory (which is already in place)
- However, when a brand from my dimtable is not listed in the selected ranking (let's say ranking is top 3 but my brand is actually a nr 10) then I want to replace nr 3 in the top 3 ranking by my brand)
- But is my brand is in the selected TopN ranking, let's say ranking is top 3 and my brand is nr 2, then it can stay at nr2.
So at all costs, my brands which are listed in a dim table, should always be presented in the ranking. Off course they have to be present in the actual list but that is always the case.
Any ideas how to fix this?
I've managed to make a dynamic ranking with a custom TopN filter, output is a table with brands ranked by TopN filter and the rest is always summed up by a total under "Others". This is because there are several subcategories. So within a subcategory the dynamic filter is working on brand level.
My question: I would like to include in the ranking always certain brands, which might not be present in the selected TopN ranking. I have a dim table with all the Brands connected to the company. So the idea would be:
- TopN filter on ranking by brand within a subcategory (which is already in place)
- However, when a brand from my dimtable is not listed in the selected ranking (let's say ranking is top 3 but my brand is actually a nr 10) then I want to replace nr 3 in the top 3 ranking by my brand)
- But is my brand is in the selected TopN ranking, let's say ranking is top 3 and my brand is nr 2, then it can stay at nr2.
So at all costs, my brands which are listed in a dim table, should always be presented in the ranking. Off course they have to be present in the actual list but that is always the case.
Any ideas how to fix this?