A pivot table is driving me insane at the moment.
A very simplified example of the data is below
Week CaseId Fix
FW01 111111 1
FW01 111112 1
FW01 111113 1
FW02 111114 0
FW02 111115 1
FW03 111116 1
FW03 111117 1
FW03 111118 1
FW03 111119 0
What the pivot table should look like is
Week Percentage
FW01 100
FW02 50
FW03 75
Seems simple, but I cannot crack it.
Help appreciated.
A very simplified example of the data is below
Week CaseId Fix
FW01 111111 1
FW01 111112 1
FW01 111113 1
FW02 111114 0
FW02 111115 1
FW03 111116 1
FW03 111117 1
FW03 111118 1
FW03 111119 0
What the pivot table should look like is
Week Percentage
FW01 100
FW02 50
FW03 75
Seems simple, but I cannot crack it.
Help appreciated.