Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe This
Sum({<Upward={"=rank(Upward)<=10"}>}Currrent QTR)