I need to calculate the 75th percentile based on price across all products, then identify what is the price on the 75th percentile.
Would you think of any elegant way to do this inside Tableau?
The result should be precise and dynamic. There can be other filters apply to the view, and we need to know exactly what the price is on the 75th percentile.
Does this formula work? IF RANK_PERCENTILE(SUM([Price])) = 0.75 THEN AVG([Price]) END