Jun 20 2022 07:13 PM - edited Jun 20 2022 07:42 PM
Might anyone have a suggestion on how to do the following?
Trying to show the daily counts of Job stages for the 6 days in the columns
I have added 4/1 data to the Rows and Values fields. and these display properly in the Pivot table
How can I get all of the Stage names to show in the 1st column of the Pivot table
How do I get the remaining Date data to show correctly in the Pivot.
Currently the other columns in the Pivot just repeat the data from 4/1
Greatly appreciated
Jun 20 2022 09:45 PM
@kelvinwbruce You need to flatten the data first. With PowerQuery you can "unpivot" the data. The attached file contains an example where I imported a portion of the date in your screenshot. Unpivoting or flattening means you create a tabular data base with one column for each field. Thus, you end up with one column for the Job, one for the Company, one for the Date and one for the Stage. From that table you can create the pivot table as you want it.
The Query in the attached file was made with PQ in Excel for the Mac (still beta). It has a different look and feel and requires a slightly different approach when connecting to a local table. But the bulk of the process is the same.
If you are not familiar with PQ, the link below is a good place to start. Chapter 13 in particular (scroll down a bit).
Jun 21 2022 09:38 AM