Convert a monthly total from a quarterly average

Question

I am trying to figure out a way to take the data below that is average data by quarter (Current View) and reverse it so that the data is populated for each month (Expected View).

atcodedog05 · Accepted Answer

Hi @ksmith

Here is how you can do it. I have slightly changed the input so that you can make out that it works with different data.

Workflow:

Hope this helps : )