Forum Discussion

Anonymous

Not applicable

8 years ago

Ranking Issues with Measures

I would like to create a Top 5 and Bottom 5 ranking based off of a Measure that is interactive based off of the filter selections. A picture is posted below(Dummy Data).. That I will further e...

Tips and Tricks

Anonymous

Not applicable

8 years ago

Hello,

Ashish_Mathur What is the best way to share the file with you ?

Thanks,

Garrett Gilmore

Super User

8 years ago

Hi,

Upload the file to OneDrive/Google Drive and share the download link with me.

Anonymous
Not applicable
8 years ago
Hello,

Ashish_Mathur could you please try this (https://drive.google.com/open?id=1Yqix6czPTLJ981_TRB8VmxnvZLi07ftW)... It has the file located within the drive... I've never used Google Drive so please let me know if this doesn't work... I appreciate your help!

I will send you a message further breaking down the file!

Thanks,

Garrrett
- Ashish_Mathur
  Super User
  8 years ago
  Your question is not clear. Please show the expected result here.
  - Anonymous
    Not applicable
    8 years ago
    Ashish_Mathur
    
    I would like to write a RANKX formula that ranks the TOP and BOTTOM 5 Country and Categories based off of IYA. So as different slicers are selected it will change the Top and Bottom 5.
    
    For example "LA" is selected in the Region slicer then the TOP 5 will show the top 5 country/categories that have the top 5 IYA and bottom 5 IYA. As the timeframe slicer is changed as well the TOP and Bottom 5 can change as well. Example LW Canada ^&8 could be in the top 5 but L52W it may not be. Below is a picture of how I invision is roughly looking but only 5 rows.
    
    I know it will be a RANKX formula and I can then use the TOPN function on the filters... Thank you for all the help and I look forward to hearing from you