I have a projects with 6 sub projects say for eg. Project1 has subprojects1, subprojects2, subprojects3, subprojects4, subprojects5, subprojects6, subproject7, subprojects8 and subprojects9
Every sub projects should have to be completed after the previous subproject.
Here SP6 finished before the SP5 finish date by 1 day. So I want to highlight the subproject SP6 and Project P1.
Do you have selected all the dimensions like you have them in your data model? Otherwise it won't work correctly. Can you share that QVF that you use?
No. I selected for a particular dimensions. Also, I am working in hub. I tried with sample data, it's working fine, but not with real data. Is there any other way?
You can try to include the sub project in the IF statement with the Above() function. It doesn't work with real data because you select your own variables.
Good, that means we're almost there. You should create another IF with:
IF(Above(Project) <> Project, Black(), IF(.... [next one]
Because every first one should be black of course.