Hi @Natsuki ,
I replicated the scenario in my environment to mirror yours.
For the percentile rank to be computed accurately, please adjust the #PercentileRank as follows:
percentileRank([SalesPerPerson DESC], [Year], PRE_AGG)
Please note that Quick Sight does not support the use of calculated fields with aggregation as a dimension group.
Instead, you must utilize the LAC-W (Level Aware Calculation) with PRE_AGG or PRE_FILTER to achieve row-level aggregation.
Result
Should you require any further assistance, please don’t hesitate to reach out.
BR