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?
This proposal adds two columns to the source data:
1. Closed 2: =IF([@[Closed Flag]]="Closed",1,"")
2. <=30 Days: =IF(DAYS([@Closed],[@Created])<=30,1,"")
3. The two new fields are placed in the Values area of the pivot table
4. A calculated field is added: ='<=30 Days' /'Closed 2'
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
HI, thanks for the reply and sorry for not coming back sooner.
There was an error with the sample I updated, it didn't include the unique reference associated to each entry, I'm not sure if that changes the solution you proposed? I've uploaded another sample with the unique ref included.
Thanks!
I am away from my computer for a few days. Will look at this when I get a chance.
No changes needed.
Added 3 helper columns and using PivotTable.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks