Posted by K. Robin on February 13, 2002 9:41 AM
I need to add in a Work on Hand calculated field in a pivot table for each month. The fields I have are:
CustomerName, OpenDate, CloseDate, Priority
I think the calculation should go something like this:
Feb2001 = All cases where open date < Feb 1, 2001 and the close date > Feb 1, 2001 (this is just a guess.....) but I need to do this for every month. I've tried many different ways with no success.
Any help would be appreciated.