Easiest way to recreate this Excel table?

I'm attempting to incorporate this data into a larger workflow. The first table is just input values while the second two tables are formulas. Fairly new to Alteryx, and I'm thinking I could do this with some formula tools and a could others, but was hoping someone could give me advice on how to do this with as few tools as possible.

The change in 2019 formula is different than the rest of the formulas in the 2nd table, and the December 2018 Actual in the third table is an input from the rest of the WF, while the rest of the data in that table can be performed with one formula.

Thanks for the help!

Workflow

Accepted answers

ImadZidan

Hello @BSmithdubz ,

That was the imputation tool. May be you don't have it in your version of Alteryx.

I have replaced it with a formula. I hope it is better.

Also with regards to the actual column, share the logic and we will figure it out.

TablesLayout1.yxmd

All comments

ImadZidan

@BSmithdubz ,

My best guess would be some data processing followed by a table Tool.

Provide some data and let us give it a go.

BSmithdubz

Here's an example data file - essentially the bottom row of data is what I need to bring into my workflow, and I'll have 20 slightly different versions of the "December 2018 Actual" numbers to bring in to get to different copies of that bottom row. The first two tables should be constant, I'd just like to get formulas in there to generate the 2nd table based on new data for the current year for the first table. Thinking the multi row formula tool might help but not completely sure if that's the way to go.

Let me know if that made any sense - thanks!

Example Weighted Averages.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703