Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Crosstab query question

Copper Contributor

I want to create a crosstab query where I can get an average for a select number of row entries. In other words, let's say I have a database with three fields: days of the week, company name, hours worked. The row heading would be the days of the week, the column heading would be the company name and the values would be average hours worked. Now, let's say I just want the average for the group of Tuesday, Thursday and Friday instead of individual averages for each day. Is there a way to do this? Thank you.

0 Replies