Hello! Pls. help me figure out how to filter my Pivotchart and do color coding based on values... Pls. see my file (in excel) for better understanding...
1. I'd like to filter only the material and show only those which weekly field from Week 1 to W9 has more than 2 values of less than 80%?... This means if values that has less than 80% from Week1 o 9 will be excluded from the report.
2. After the 1st condition met, color the percentage to red if at least 1 below 80% falls from W1 to W6, IF the below 3 below 80% falls from W7-9, then yellow...
Hoping for your help on this...I already spent days on this how to figure out my dahboard...
Tks.
