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