Forum Discussion

llealsantos's avatar
llealsantos
Frequent Visitor
2 years ago
Solved

Rank function on selected dates

We need to apply conditional formatting to identify the top 5 and bottom 3 values in a dataset, based on user-selected fiscal periods. The selection can include non-continuous fiscal periods, and the...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    please check the rankx function what I have used on the dataset.


    Please check the final output.

    If you think that this helps you then accept this as your solution.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

please check the rankx function what I have used on the dataset.


Please check the final output.

If you think that this helps you then accept this as your solution.

llealsantos's avatar
llealsantos
Frequent Visitor
2 years ago

Thank you!! It was that ALLSELECTED that was missing