how to display actual and forecast data by different color

[Former Member]

Hi, Friends,

I need display actual data and forecast data by different color in query. (all keyfigue >=current month need show different color).

So, can I do it in Bex? if it need VBA, Pls send to me sample code.

Thanks!

[Former Member]

Hello Sam,

You can create exceptions for doing this. In the exception, select 0calmonth characteristic and set its value - current month. Select color of your choice. This will give you color for forecast data. Then create another selection for Actual data.

Thanks

[Former Member]

Thanks George,

But exception only work for keyfigure. how to set logic for 0calmonth and current month?

Thanks!

[Former Member]

Hello Sam,

Yes, you are right. Sorry for that. Let me see if i can get any solution.

Thanks

[Former Member]

Any idea?

Thanks.