Hi!
I have a query that returns the productivity of a project during a period, and other that gives me which employees where working on the project at the period. I can't tell how much each employee producted, all I can say is that one employee worked on the project on that period.
When I join both queries I obviously get repeated rows:
Proj1 Employee1 1000
Proj1 Employee2 1000
Proj1 Employee3 1000
But I would like to have both information on the same matrix like this:
Project Employees Total Project Productivity
Proj1 Employee1 1000
Employee2
Employee3
I mean, I don't want the total project productivity to appear once for each employee.
I also tryed to change the order, putting the employees on the data cell:
Project Total Project Productivity Employees
Proj1 1000 Employee1
Employee2
Employee3
but I got only the first employee name (it uses function first).
Is there anyway I can do any of the matrix above?
Thank you!
On this process
When I join both queries I obviously get repeated rows:
Proj1 Employee1 1000
Proj1 Employee2 1000
Proj1 Employee3 1000
Use suppress duplicate rows on the property on the proj1 and 1000 column, that should get you this
Proj1 Employee1 1000
Employee2
Employee3
Carl
|||Thank you!
No comments:
Post a Comment