Dynamic Filters - filters for Rank function returns unintuitive results.
Explanation of behavior:
If you create a calculated field using the rank function, then use it as both a filter and a field in the report, it may appear that you get inconsistent values.
For example, the rank field values always start with 1, no matter whether you include the value 1 in your filter.
This is because the rank value used in the field and in the filter are actually different; the rank value used for filter is applied to the unfiltered dataset. The rank value used for the column is applied to the filtered dataset, so it will change whenever the filter changes.
This is true of the rank calculation on any filtered dataset.
Recommended Comments
There are no comments to display.