The resource demand and financial analysis query subjects display the current workgroup of the resource. They do not take into account workgroup changes that are scheduled for the future.

To report on effort or resource demand per workgroup that includes future changes, you must build custom SQL queries.