Skip to Content
0
Oct 10, 2012 at 01:04 PM

BEx exception on deviation within rows

45 Views

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 17

To 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 17

I 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