Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
is it possible to display Appointments from different Employees in a Pivot like you can see in the attached .png file?
If i concatenate the tasks in one cell, i got a fine solution, but i need a cell for each task. It is important, that each week/day/date is shown only one time in the pivot table.
Any solutions here?
Thank you!
Hello,
Hope it helps you. Can you see the attached file.
Hello,
in your example each employee(1-3) is a dimension.
But i dont know how many Employees i want to display, i got only 1 dimension which contain all employees.
So you have only one field which contains all the employee names. Say for example;
EmpField
Emp1
Emp2
Emp3
- Then what about the tasks? from which field you are getting the task?
Can you please show your datamodel.
The Datamodel is very simple, its like this:
Task | Employee | StartDate | EndDate |
1 | A | 01.07.2012 | 01.07.2012 |
2 | A | 01.08.2012 | 02.08.2012 |
3 | A | 02.08.2012 | 02.08.2012 |
4 | B | 01.05.2012 | 05.05.2012 |
5 | B | 02.05.2012 | 02.05.2012 |
6 | C | 03.05.2012 | 03.05.2012 |
7 | C | 04.05.2012 | 04.05.2012 |
Any other ideas?