Prashanth Kumar 4 Posted April 19, 2020 Share Posted April 19, 2020 I want to highlight the cell valuesof a calculated column which are lesser than Grand total value in the cross table, I have attached the sample excel file showing the same. Note : All the values in this caluclated column are in Percentage format Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted April 19, 2020 Share Posted April 19, 2020 This is how I tried with a sample data set. I created a rule for that particular column and used the expression to color the cell background if the cell value is less than (Grand Total/3). Although your use case is a little different, but it would be worth leveraging this and give it a try. Link to comment Share on other sites More sharing options...
Prashanth Kumar 4 Posted April 19, 2020 Author Share Posted April 19, 2020 It is not working for me , I am actually trying it on calculated column, I tried the above method but was not successful. Am I missing anything here Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted April 19, 2020 Share Posted April 19, 2020 If you can share your DXP file with embedded data, I can take a look.. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now