on 04-11-2017 1:44 AM
Is it possible to show negative numbers in a cross tab red?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.