Calendar Overview (Pivot)

[#1]

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!

[jagannalla]

Hello,

Hope it helps you. Can you see the attached file.

[#3]

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.

[jagannalla]

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.

[#5]

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

[#6]

Any other ideas?