3 Replies Latest reply on Jan 5, 2018 10:31 AM by Yuriy Fal

    Index and Ranking in 1 chart

    Tony Phan

      I'm trying to rank in a window but it's not working the way I want it to. I filtered to top 25 distributors using Index and I'm ranking off of different criteria (the % in the screenshot below)

      In my table when I use the rank function, it's ranking within my whole list and not within that window. Below are some screenshots. I also tried "commute using" and it didn't work. Sorry i don't know how to attach the workbook without all the data behind it. Please help! Can we set up a meeting if you can help?