Dynamic Ranking based on Filter selection

PrevContributor
PrevContributor
in Modeling

I am trying to implement a ranking function which based on user selection of filter on a hierarchy list provides top 5 records i.e if he chooses the lowest level in hierarchy he gets top 5 results on that, but if he chooses the level above he gets top 5 on the Parent item in the list. So is there a way to pass the group to the Rank function based on what the user selects in the filter?

Tagged:

Best Answer

  • elizabeth_schaf
    elizabeth_schaf
    Answer ✓
    Based on my knowledge, the calculation functions do not recalculate based on the filter. If you have other questions, let me know.

Categories