7 Replies Latest reply: Dec 12, 2014 11:03 AM by phillip colbert RSS

    Rank in Textbox as KPI

    phillip colbert

      Afternoon all!


      i need to use the Rank function in a textbox as a KPI


      i.e. without the dimension - just as an expression. i only want to display the rank of a single product.


      For example i have 20 products with sales volume. i want to display in a text box the rank that one particular product is at. I've got this working fine in a chart with a dimension - but i have no idea how to script this as a single expression.


      so as a chart this works perfectly:

      Dimension: Products

      Expression: =rank(sum(Sales_Volume))


      but how do i go about writing the expression to take into account the dimension?