Table (matrix) with TopN and others

This one is a bit tricky but solves a common wish of showing af table with the Top number of x plus others.

There are several tricks involved in this one - first we use a matrix and add the numeric fieldparameter value to the rows and then the attribute we want to group the items by - hide the +/- icon and then we use different visual calculations to show the attributes value if is matches the rank number of the product.

Visual calculation functions used:

EXPAND

RANK

ISINSCOPE
RUNNINGSUM

A large dataset will affect the performance and you might want to consider alternatives

Enjoy visual calcs

Erik