how to calculate difference between two dates in pivot table / Pivot Table - Calculate Difference From - Microsoft Community

how to calculate difference between two dates in pivot table

how to calculate difference between two dates in pivot table

Joined Feb 28, Messages Replies 2 Views I would like to have a dashboard reporting, at the end of each month, the average 'age' of opened issues. This makes it easier to read the formula and helps reduce errors. My suggestion would be to solve this with the PowerPivot. Joined Nov 15, Messages 1, It's most common to compare values based on a date field, but you can use any row or column field as the base field.

Get Started

HOW TO CALCULATE DIFFERENCE BETWEEN TWO DATES IN PIVOT TABLE / janiceclark.net