Hi,
The rank is showing perfectly. However, when I apply a filter to display just the top 5 the % numbers change. How do I keep the % number from changing when applying the filter?
Thanks,
No filter applied with % being correct:

Top 5 filtered applied with % being incorrect:

Hi @taraallison82
Can you please share the ranking formula used and field on which the filter is applied?
Regards
Vetri
Hi @n_vetri
The ranking formula is: rank([{GROUP} DESC]).
Filter:

Hi @taraallison82
You may want to use Level Aware Calculation with PRE_FILTER to compute your total so that the percentage is computed over the entire data rather than on the filtered data.
Regards
Vetri
2 Likes