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: