This content has been marked as final. Show 2 replies
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.