Rank and Median

From the Calculations Smartpad you can add pre-defined Rank and Median calculations.

Like the Average calculation, the Rank and Median calculations makes most sense when they refer to ranges, e.g. an all range.

The default pre-defined calculations are:

• median(d-1, all, m1)
• rankdesc(d-1, all, m1)
• rankasc(d-1, all, m1)

For a standard crosstab with No of Sales per Customer Country, this would give a result like this: