Hi Excel Forum Members,
I'm searching for an elegant and effective solution for the following challenge:
My data set contains information when a case was reported (Date reported) and also when a case was closed (Date closed). If the case is not closed yet, the cell "Date closed" remains empty. Each case is assigned to a handler (Person 1 - 5).
I know how to insert a quick Pivot Table to analyze the current status of how many open cases does each loss handler have today.
What I'm trying to achieve is a bar chart to show the development of open files at defined dates. In my file, I have set monthly dates and counted the amount of open files at that day manually... I'm trying to find a way to analyze:
On each defined date, please count the number of files per case handler that were opened before the defined date and not yet closed on that date. With that analysis, I want to visualize the workload per case handler over time.
I hope I described my goal well enough, in case of any questions please let me know.
Looking foreward to your comments and thanks for your support,
VB_75
Bookmarks