Hi all,
I have a report that contains the date an item was created, the date it was closed and a closed flag, and I need to work out what percentage of items were completed within 30 days on a month by month basis (the target is 80% within 30 days). I'm not sure if I can do it in a pivot or a power pivot (a haven't had much experience with power pivot). I've attached some sample data, could anyone give me any pointers please?
Bookmarks