NenadIlic
8 years agoQrew Assistant Captain
Creating a tree report with specific colour fields
I am trying to create a report that would function in a specific way, and specific look, thus I could use your help if anyone knows.
So practically I would need to group data in a tree maner (expand is optional):
Example (something like in ghant chart, but without timeline like that - but keeping the grouping):
Customer Name 1
- Category 1
* Task 1
* Task 2
- Category 2
* Task 1
* Task 2
Also on a side I am looking for a way to highlight cells that would be on the side. The idea is that all tasks pass through same phases and this is all settled. What I would need now is that if the Criteria for Phase 1 is not met to color only that field (not coloring others), and if Criteria for Phase 2 is not met, color only that field.
I apreciate it.
So practically I would need to group data in a tree maner (expand is optional):
Example (something like in ghant chart, but without timeline like that - but keeping the grouping):
Customer Name 1
- Category 1
* Task 1
* Task 2
- Category 2
* Task 1
* Task 2
Also on a side I am looking for a way to highlight cells that would be on the side. The idea is that all tasks pass through same phases and this is all settled. What I would need now is that if the Criteria for Phase 1 is not met to color only that field (not coloring others), and if Criteria for Phase 2 is not met, color only that field.
I apreciate it.