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 StartedHOW TO CALCULATE DIFFERENCE BETWEEN TWO DATES IN PIVOT TABLE / janiceclark.net
- Secure and Private
- Easy to Use
- Find Matches Quickly
- Verified Profiles