How to create two calculate dimensions in a pivot table?
Hi everyone,
Im trying to have in a pivot table, some dimensions i'm calculating. De information i´m analising comes from a unique table that has the following values:
Descripción process // Description task // time // type of task (1 or 2)
I would like to obtein the next table:
Process Descriptión Number of tasks 1 Time 1 Number of Task 2 Time 2
P1 Task 1 3 30 5 70
Task 2 234 55 45 35
Task 3 - - 2 49
P2 .............
What i'm trying is to calculate Time 1 just counting and adding the time of the rows that have type of task =1, and for Time 2, the rows that have type of task = 2. Is this type of calculation posible?
I have try this but it doesnt work: If (TASK_TYPE = 1, (SUM(subfield(TIME,':',1))/ count(TASK)))
