Convert a monthly total from a quarterly average

[ksmith]

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 solution]

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 : )

[atcodedog05]

Happy to help : ) @ksmith 

Cheers and have a nice day!