Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Formatting for specific column down in Hierarchy

Hello everyone,

 

I'm facing an issue about specific conditional formatting, and I don't know if it's possible to do what I'm asking.

 

I have a matrix like the one below

Status

OK

 

KO

 TOTAL 

Customer

N pieces

   %

N pieces

   %

N pieces

   %

AAA

70

   70%

30

   30%

100

   100%

BBB

93

   79.5%

24

   20.5%

117

   100%

 

That view is clearly the one I obtain after drilling down for columns.Status and Customer are my Columns, and my Rows are Customers.

 

I would like to format only the % column under KO column (the one in red)   so that it shows in red only percentages below 25%

 

 

Is it possible? or there is some workaround?

 

thank you a lot

 

 

EDIT.

 

here is my clean sample data

Data IdIncarico Cliente SLA Status
1/1/2019 1001 AAA a OK
1/2/2019 1001 AAA b OK
1/3/2019 1001 AAA c OK
1/4/2019 1002 AAA a OK
1/5/2019 1002 AAA b OK
1/6/2019 1002 AAA c OK
1/7/2019 1005 AAA b OK
1/8/2019 1005 AAA c OK
1/9/2019 1005 AAA a KO
1/10/2019 1006 AAA a KO
1/11/2019 1006 AAA b OK
1/12/2019 1006 AAA c KO
1/13/2019 1011 AAA a OK
1/14/2019 1011 AAA b OK
1/15/2019 1011 AAA c OK
2/9/2019 1008 AAA a OK
2/10/2019 1008 AAA b OK
2/11/2019 1008 AAA c OK
2/12/2019 1009 AAA a OK
2/13/2019 1009 AAA b OK
2/14/2019 1009 AAA c OK
2/15/2019 1010 AAA a OK
2/16/2019 1010 AAA b OK
2/17/2019 1010 AAA c OK
2/21/2019 1003 AAA a KO
2/22/2019 1003 AAA b OK
2/23/2019 1003 AAA c OK
2/24/2019 1004 AAA a OK
2/25/2019 1004 AAA b OK
2/26/2019 1004 AAA c OK
2/26/2019 1007 AAA b KO
2/27/2019 1007 AAA c OK
2/28/2019 1007 AAA a OK

lbendlin yes i've made a mistake, no i've correct the formatting.

 

thank you!

Need Help
Tips and Tricks

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    While you cannot do that for individual columns you can do it for measures. You would need to use ISINSCOPE() and the desired dimension value to sense if the conditional formatting should be applied or not.

     

    Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome. You say below 25% yet you show 30% as red?