3 Replies Latest reply on Mar 16, 2017 8:20 AM by Tom W

    Rank/Index() not linked to other fields after drilling down in hierarchy!

    Cornell Thomas



      I have a simple question here that I haven't been able to figure out. I'm currently building a report for my boss. I need to show top 50 dollar amounts. I created the calculation for rank but it's not linked to the field dollar amounts after drilling down in the hierarchy. Works fine once I roll up the hierarchy. Here's a snippet of what I'm seeing. Due to an agreement with my employer I cannot share information.



      Notice how number 3 should be number 1.


      Any suggestions or ideas?


      Thank you!