Forum Discussion
Table Summary Sheet Organization Help!
with the current structure of the data table, a Pivot is not possible. So my recommendation is to load the data table into Power Query, transform it with "Unpivot" function and load it directly into a new Pivot table in the Summary sheet. There you can use slicers to select the employes.
In the attached file I have prepared that. You just need to refresh the pivot whenever something changes in the data table.
with the current structure of the data table, a Pivot is not possible. So my recommendation is to load the data table into Power Query, transform it with "Unpivot" function and load it directly into a new Pivot table in the Summary sheet. There you can use slicers to select the employes.
In the attached file I have prepared that. You just need to refresh the pivot whenever something changes in the data table.