4 Replies Latest reply on Oct 28, 2018 10:51 AM by Jesus Fandino

    Rank changes when applied a filter based on other field (opposite to what I need)

    Jesus  Fandino

      Hello there.

      This might be easy, but I have been struggling for a while now.

      I have an IMDb dataset and I created a calculated field Profit = [Gross Revenue] - [Budget]

      I plotted the director names vs Budget (horizontal bars) and applied a rank to them based on Profit (that rank goes from 1 up to 1733). That works just fine, however, if want to filter the top ten director names based on Budget, then my ranks change (1 up to 10) and that is NOT what I'm looking for.

      Any help will be very much appreciated.

      Thanks

      Jesus