I created a pivot table that has name, month, then date in the columns field.
The dates values are not sorting in chronological order. I made sure the raw data for the date values are not text and are in date formatting.
The end goal is to quickly see by month employees actual sales and if need be, drill down into dates.
The dates values are not sorting in chronological order. I made sure the raw data for the date values are not text and are in date formatting.
The end goal is to quickly see by month employees actual sales and if need be, drill down into dates.