Ranking & Filter

Question & Answer
,
1

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:

image

Top 5 filtered applied with % being incorrect:

image

2

Hi @taraallison82
Can you please share the ranking formula used and field on which the filter is applied?

Regards
Vetri

3

Hi @n_vetri

The ranking formula is: rank([{GROUP} DESC]).

Filter:

image

4

@n_vetri

Is there an update?

Thanks,

5

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

1 Like