Dear forum,
in my BEx Query executed in BEx Analyzer I'd like to mark the deviation of key figures along the rows. This is what the query looks like:
January
Count
February
Count
March
Count
April
Count
May
Count
June
Count
July
Count
CostCenter1 15 15 18 18 18 17 17 CostCenter2 10 10 10 10 10 10 10 CostCenter3 13 13 13 18 16 16 17To give the user a fast overview the deviation along the row, in this case within the cost center should be highlighed. The following cell should turn red if the value is higher then before and should turn green if it's lower.
January
Count
February
Count
March
Count
April
Count
May
Count
June
Count
July
Count
CostCenter1 15 15 18 18 18 17 17 CostCenter2 10 10 10 10 10 10 10 CostCenter3 13 13 13 18 16 16 17I tried to use exceptions but could not find the correct setting. Even with additional key figures that calculate the deviation by subtraction I only could make it work correctly in BEx Web Analyzer and only when these auxiliary key figures are visible at runtime.
Is it possible to do such highlighting?
Thank you very much in advance!
Anna