Forum Discussion
Matrix same values assigned to every row
Hello, I have a matrix with line manager at the top row, below there are employees under this manager and project descriptions The values are billable and unbillable hours. I'd like to have count o...
can u provide sample data?
billable hrs table sample
EmpID EmpName Billable hours 1 John 10 2 Steven 10 3 Anna 10 4 Monica 10
Project table sample
ProjID EmpID ProjDsc ID1 1 Project1 ID2 1 Project2 ID3 2 Project3 ID4 3 Project4 ID5 4 Project5 Nonbillable hours table
EmpID NonBillableHours ID1 5 ID3 5 Really straighforward. Employee can have nobillable values in several rows etc
Then I create a matrix with emp name, projectdesc as rows, billable nobillable horus as values
and now, because ID1 has 5 nobillable hours, it shows that it has "5" nobillable hours under his projectdesc, when I want it only at the name level, not when I expand the projectdesc
