Skip to Content

Hi All,

Recently I came across a requirement wherein we had to show 2 different colors on the same chart (blue and yellow) for one dimension which has 7 different values.

Ex: Mon, Tues, Wed, Thurs, Fri, Sat, Sun are the dimension values. The customer wanted the value on the chart for Monday coming in Yellow whereas for others in blue.

This is only possible in SAP BO 4.0 + as there is an option on the chart to put formulas in charts. This is the way I achieved it. Below is the sample table I created from efashion to demonstrate the way I did it.

Table.PNG

Then I changed the above table to column chart.

Direct Conversion of Table.PNG

Notice I have set the graph to change colors based on the state. Hence for each state I will get a different color. After this I used a simple formula for grouping

Formula for Graph.PNG

In the State Dimension, i placed a formula like if([State]=”California” then “California” else “Other States”. This formula will group California and remaining states as 2 different sub-sets of data on the graph as seen below.

Formula Conversion of Table.PNG

In a similar way I achieved the desired reults for me showing yellow color bar for Monday in each week and blue for other days in the week so that the customer can easily understand the beginning of the week when they look at the chart directly.

Hope this helps you in some way.

Regards,

Sanjo

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply