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

      Hello,

       

      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!