Hi!
Could someone helped me with my formula? I have a 36 weekly buckets from W1 to W36...
1. I'd like to filter only the material field to show only those which weekly field from Week 1 to W9 has more than 2 values of less than 80% (in Coverage item in Key Figures field)? ... This means if values that has less than 80% from Week1 o 9 will be excluded from the pivotchart. I would prefer to place my expression in the material as I already have an expression in the
2. After the 1st condition met, I need to create a new column "Color Code" to place "Red" if at least 1 below 80% falls from W1 to W6... IF the below 3 below 80% falls from W7-9, then 'Yellow'... I believe this need a complex set analysis formula and really had a hard time composing the formula.
Tks.
P.s. I have attached my sample file for easy understanding.