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
