Excelrookie86
New Member
- Joined
- Mar 22, 2022
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi All,
I have 3 workbooks that I have used PowerQuery to append together.
The source data is from Microsoft Planner.
Planner allows me to assign MULTIPLE users to a task which is great for shared items.
Problem: The group show up as an ID in my pivot chart.
Any ideas on how to resolve this?
I'd ideally like it to count a combined task as a task for each member.
For example I'd like the image below to take this task and add it to Mai's count and also to Anthony's count.
So this group would disappear and the task would be counted by staff member name.
I have 3 workbooks that I have used PowerQuery to append together.
The source data is from Microsoft Planner.
Planner allows me to assign MULTIPLE users to a task which is great for shared items.
Problem: The group show up as an ID in my pivot chart.
Any ideas on how to resolve this?
I'd ideally like it to count a combined task as a task for each member.
For example I'd like the image below to take this task and add it to Mai's count and also to Anthony's count.
So this group would disappear and the task would be counted by staff member name.
