Show fields in Pivot table
Hello.
I have a Form with 3 fields: Task, Role, and Responsibility. For each Task, a Role can have different Responsibilities.
For example, having Task1 and Task2, and Role1, Role2 and Role3, the data rows could be:
Task1, Role1, Responsibility1
Task1, Role1, Responsibility2
Task1, Role1, Responsibility3
Task2, Role2, Responsibility2
Task2, Role3, Responsibility2
And so on.
What i need to have is a cross table with Tasks in rows, Roles in columns, and all the Responsibilities for the Task-Role pair.
I have tried using a Pivot table, but it only shows calculated fields (for example, the number of responsibilities for each Task-Role pair).
is there a way to customize the Pivot table so it can show the fields' values instead of calculations?
Thanks in advance.