I have a simple graphical table that utilises three calculated columns. As illustrated in the attached example the table is divided into subgroups corresponding to indicators and respective time series. In addition, the first calculated column is filtered by the case name whereas the last two columns disregard the data filtering and calculate corresponding averages and medians. I would like to add more columns in particular I'm interested in:
- Adding a calculated column that will display absolute difference to the average
- Adding a calculated column that will display relative difference to the average
- Calculated column that would provide a ranked position for a given case in the data set according to the indicator and corresponding time series.