SAC Table Threshold based on one KPI but display on another?

[vitran23]

Does anyone know if there is the ability now or in the future where you can set the threshold based on one KPI but display the output on another KPI? Example is within a BEX query where you can set the exception to be calculated on column B but display the coloring on column A?

[saikhancs35]

Hi,

When i am trying to use above option, the measure option is coming disabled to me. Any idea, as what could be the reason for that? I am using BW4HANA Live connection.

Below is my requirement:

I have a table showing Period Accuracy and Target. I want to highlight period accuracy based on target value.

So if [Target]-[Period Accuracy] >2 then green color, if [Target]-[Period Accuracy] = 2 then red color, if [Target]-[Period Accuracy] > 2 then red.

Please ignore the numbers as this is dev data.

[N1kh1l]

saifkhancs35

Threshold based on another measure is not supported on live connection. Its supported on imported connection model only.

There is an influence request for the same which can be upvoted

Improvement Request Details - Customer Influence (sap.com)

Nikhil