Pivot Table Field Grouping

Hi Graham

Thanks for your question

To group in the way you are requesting, you would need to group on "weekday", which is unfortunately not available in pivot tables.

One solution would be to insert a column into your data, and insert the weekday function. This function converts a date into a number that represents the day of the week on which it falls. You can then use this field in your pivot table as a row or column field, and the data will then be grouped as you require.

Regards

Stephen