In this article
Range setting has is useful when result needs to be split up in multiple tables/charts due to space issues.
Below we see an example where all countries are sorted by value but shown in three different tables.
Each of the tables originally contains all the countries however the most left table shows top 10 rows only while middle table shows rows 11-20 and furthest right table rows 21-30.
The Range setting is an complementary to the already existing Show Top-X and Bottom-X items.
Below you see where to find the new setting.
If the table/chart contains benchmark or ranking which is applied to the same position as the Range you can select if the “Range” operation should be applied before or after the benchmark or ranking calculations.
Note: The setting shows up only when Range and the Benchmark/Rank is applied to the same position, in this example both the Range and Benchmark is applied to Rows.