8 Replies Latest reply: Oct 20, 2016 6:23 AM by Massimo Grossi RSS

    count top 10% customers

    Eldad Tsipris

      Hi,

       

      I need to display in a textbox how many customers are in the top 10%...

       

      Itried to use

      count({$<Customer= P({<Sales ={">=$(=Fractile(Total Sales,0.9))"}>} Customer)>} DISTINCT Customer)

      but didn't get the same results as I get when using Dimension Limitation in a chart object....