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?

       

      cheers!