Hello,
I have problem when try to add a calculated field "duration" in a pivot table as follows:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I want the duration should be 14 days.
I see the calculated fields is only correct for each row of a table , not for the 2 final result columns of a pivot table.
How can I subtract 2 columns in a pivot table duration= max[enddate] - min[startdate].
please help.
Thank you.
I have problem when try to add a calculated field "duration" in a pivot table as follows:
min[startdate] | max[enddate] | duration | |
project 1 | 2/7/2017 | 2/21/2017 | 8 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I want the duration should be 14 days.
I see the calculated fields is only correct for each row of a table , not for the 2 final result columns of a pivot table.
How can I subtract 2 columns in a pivot table duration= max[enddate] - min[startdate].
please help.
Thank you.