Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Would you please let me know how I would handle filtering a field (for example a client number) so that I can display the top "N" of it in a chart by different dimensions (for example, by product or region or revenue size)? I know that I can limit the display on the dimension limits page by using the "Restrict which values are displayed..." but it still has to sort through all the values in order to limit by order so is there a way to limit the amount it sorts through first, please?
Thank you
No, there isn't. If you want a Top N, then the values will be sorted first. If you want to restrict values by other criteria first, for example the values for only one region, then make the appropriate selections first.
You could probably use a dynamic set analysis with a variable to filter different dimensions in this way:
=sum({<$(vDimension)={'$(vDimValue)'}>} MeasureField)
Thank you! I did end up using set analysis that looked something like this:
Sum({<Client={"=Rank(Sum($(Sales)),4)<=$(vTopN)"}>} $(Sales))