Good morning,
I have a table that has the following fields and field types:
Project_Code (Type: Short Text)
Project_Objective_Code (Type: Short Text)
Project_Objective_Statement (Type: Long Text)
Objective_Level_Indicator Code (Type: Short Text)
Objective_Level_Indicator_Statement (Type: Long Text)
Activity_Under_Objective_Code (Type: Short Text)
Activity_Under_Objective_Statement (Type: Long Text)
Activity_Level_Indicator_Code (Type: Short Text)
Activity_Level_Indicator_Statement (Type: Long Text)
I want to create a report grouped by:
1. Project Objective Code
2. Project Level Indicator Code
3. Activity Under Objective Code
When I do this, activities are grouped in project level indicator grouping. I have been working on it for two days, but no progress.
Attached is the table with example data. Thanks in advance for sharing your learning.
Thanks,
Dhamdard
I have a table that has the following fields and field types:
Project_Code (Type: Short Text)
Project_Objective_Code (Type: Short Text)
Project_Objective_Statement (Type: Long Text)
Objective_Level_Indicator Code (Type: Short Text)
Objective_Level_Indicator_Statement (Type: Long Text)
Activity_Under_Objective_Code (Type: Short Text)
Activity_Under_Objective_Statement (Type: Long Text)
Activity_Level_Indicator_Code (Type: Short Text)
Activity_Level_Indicator_Statement (Type: Long Text)
I want to create a report grouped by:
1. Project Objective Code
2. Project Level Indicator Code
3. Activity Under Objective Code
When I do this, activities are grouped in project level indicator grouping. I have been working on it for two days, but no progress.
Attached is the table with example data. Thanks in advance for sharing your learning.
Thanks,
Dhamdard
Last edited: