1 Reply Latest reply: Jun 14, 2017 3:43 PM by Rupam Das RSS

    Trying to Rank on a measure that is not visible on a pivot

    Dan Coen

      Hello,

       

       

      I have a pivot table that shows top 10 upward trends for customers based on 4 QTRS. the upward trend is a expression that I want to drive the results behind the scenes, I don't want the upward column on the table. That is fine for sorting as I can do so by the expression, but I am having a hard time only displaying the top ten with out the column there. Currently, I am using dimension limits, but that's contingent on the upward measure next to the dimension. I was thinking the rank function, but am not sure how to apply it here.

       

       

      Any help/suggestions would be great!