cancel
Showing results for 
Search instead for 
Did you mean: 

Design Studio - Show Negative Numbers Red

Former Member
0 Kudos

Is it possible to show negative numbers in a cross tab red?

Accepted Solutions (1)

Accepted Solutions (1)

former_member276213
Active Participant
0 Kudos

Hello Jereme,

Yes it is possible to display cross tab negative numbers red.

I am assuming that your data source is bex query.Please follow the below steps.

1.Set up an exception for the keyfigure value you want to display red eg in bex query if keyfigure less than 0 the set it to bad 3 (that is red and alert 9 in design studio)

2.Turn on the conditional formmating in your cross tab.

3.Write below css

.sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlternating{ background-color:#FFFFFF !important; } .sapzencrosstab-DataCellDefault{ background-color:#FFFFFF !important; } .sapzencrosstab-DataCellAlert9Background, .sapzencrosstab-HeaderCellAlert1Background { color:red }

4.you can see the desired out put, i have replicated your scenario, i got the result what you are expecting.Please refer the attachment, you can ignore the icons from the attachment.alert.png

Feel free to let me know if you have any further questions.

Best Regards,

Lakshmikanth Adharapurapu

Former Member
0 Kudos
Thank you so much. This worked awesome and very easy to follow!

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

You have some options:

1. Format the numbers in red using Analysis Office (recommend using the latest version 2.4) and then using that as a data source to Design Studio

2. Look at the options in this blog - https://blogs.sap.com/2016/11/16/changing-bar-colors-sap-design-studio-1.6/comment-page-1/

Former Member
0 Kudos
Thanks Tammy - Our company just got Design Studio and I don't have access to Analysis Office. I was looking at the blog and if I'm understanding correct I tried using the DOM Explorer but I don't see anything for cross tab that shows "negative-datapoint". Does that mean it's not possible to specify with CSS? Thanks for any insights!
TammyPowlas
Active Contributor
0 Kudos

Are you sure you don't have Analysis Office? It usually comes with the suite license.

Former Member
0 Kudos

We do own Analysis Office but IT has not released to users yet hopefully in the near future.