It is not possible to filter on KPIs which are aggregated within the OLAP table however here is a possible work around.
First, you have to create specific buttons, where you can select the % threshold for the KPIs (i.e Button dropdown with a variable "KPI1_critical_limit " and Manual Input with thresholds of your choice i.e. >10%, >15%, >20%…, >80% - IMPORTANT, the variable for this button needs to be 0.1, 0.15, 0.2 …, 0.8 --> Celonis needs the “.” as separator for decimal values). If you want to add an upper and a lower threshold then you need two buttons per variable.
Second, add a new KPI to your table with a name like ‘Critical’. Here you can use a case when statement to find the cases where all the KPIs are within the thresholds specified in the drop down.
CASE WHEN KPI(YOUR_SELECTED_KPI_1) >= <%= KPI1_critical_limit %> AND KPI(YOUR_SELECTED_KPI_2) <= <%= KPI2_critical_limit %> AND … [add all KPIs filtered on]
THEN ‘Yes’ ELSE ‘No’
After that you need to sort the entire OLAP table according the new variable ‘Critical’ so the ‘Yes’ are on top. I would also advise adding colour mapping to make the critical values really stand out.
Hope this helps.