Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have the following table with the rawdata:
NR | Project | Task | KST | KOA | ID | Description | Status | Assignee | Risk Level | Deadline |
1 | API Design 2 | Closed | John | Medium | 18.09.2016 | |||||
2 | API Development 2 | Behind | Martha | Low | 31.08.2016 | |||||
3 | API Testing 1 | Work in Progress | Jill | High | 14.07.2016 |
and I need to produce the following pivot:
Task Status/Priority | High | Medium | Low | Total | % of Total | |
Closed | 0 | 1 | 0 | 1 | 25% | |
Work in Progress | 1 | 1 | 0 | 2 | 50% | |
Behind | 0 | 0 | 1 | 1 | 25% | |
Not Started | 0 | 0 | 0 | 0 | 0% | |
Total | 1 | 2 | 1 | 4 | 100% | |
25% | 50% | 25% | 100% | 6.25 |
Any Ideas how to achieve a pivot with percentages?
Thanx and best regards
Would you be able to share a sample?
Hi Sunny T
I have the following excel with the rawdata and the mockup dashboard as it should look like.
Best regards