Skip to Content
0
Aug 23, 2023 at 07:11 AM

specify specific dimension for rankBy in Table

116 Views

Hi,

there is a table with 2 dimensions on rows (e.g. country and product) and 1 measure in columns.
with the code below ranking will result in the top 5 countries and withing those 5 countries the top 5 products:

Table_1.rankBy({relatedDimensions:{[Alias.MeasureDimension]:"Measure_ID"},rankOrder:RankOrder.Top,value:5});

However, I would like to show a table with all countries => ranking should only be attached to products.
Result: all countries & top 5 products for those countries.
how do I have to adjust code above to achieve that - applyToEachDimension:true/false does not have any effect on result. (Bex condition would work as well, but those can not be selected/deselected with javascript yet).

thank you & have a nice day
edgar