Attempting to create a Pivot Table widget in Analyze that displays effort per month associated with a project. Basically a Pivot version of a workload chart. Goal is to have a reliable projection of upcoming effort over the length of the project/contract. I just can't wrap my head around how to display/calculate the distribution of those hours over the duration of the task within the widget. As it stands, it is displaying the total effort value in the month of the task's start date.
e.g. In the image above, column of 7/2022, the task that is contributing that 48 value spans 12 months...but it only displays the lump some of hours based on the start date of the task. I would like it to display 4 hours every month.
It's either the field I am using for the columns, the effort per month value, or a combination of both. I believe updates to those two fields and some trick formulas should get me where I need to be, I just need a nudge in the right direction. Any help is appreciated. Thanks!