Find highest values for different Dimension combinations

Hi,

Let's assume I have a KPI (Measure) that can be displayed by different Dimensions (e.g. Country, Location & Region).

Is there any possibility in SAC that I can show the highest values of the KPI considering all the possible combinations of the dimensions. Like in Country X and Location Y the values is above a specific threshold). So basically that it checks all possible combinations of dimensions and displays the KPI with these respective dimension values.

Reason is that I would like to avoid showing multiple bar charts for each dimension that then shows the highest values. It should rather inform me which combinations have high values that are above a threshold.


Thanks"