2 Replies Latest reply on Nov 24, 2017 4:42 AM by Leanne Vermeulen

    Rank Percentile Across Multiple Members Not In View

    Leanne Vermeulen

      Is there a way to calculate the percentile ranking of a single customer, compared to all customers, even when only one of those customers is in the view (selected using a filter)?


      For example, I want the percentile ranking of customers calculated by the total sum of sales they've made. The "Percentile" table calculation is exactly what I want; but without the limitation of a "table calculation".


      What I need is a view that filters by one customer at a time and yet still shows their percentile rank when compared to the total sales of every other customer.


      Is there a way to accomplish this?


      I tried playing around with the RANK_PERCENTILE(SUM([sales])) calculation but that only seems to work at row level.


      Percentile_Rank Example.png