Excel formula

[Kaustubh17]

Hi team,

i have the attached the Alteryx result.

Prod

Unit

24-Apr

24-May

24-Jun

24-Jul

24-Aug

24-Sep

24-Oct

24-Nov

24-Dec

25-Jan

25-Feb

25-Mar

Q125

Q225

Q325

Q425

Clinker Prod

KMT

218

162

255

264

246

260

257

257

226

203

245

271

(Apr24+May24+Jun24)

(Jul24+Aug24+Sep24)

(Oct24+Nov24+Dec24)

(Jan25+Feb25+Mar25)

How i can get the Q125 to Q425 values in  the same row of the clinker prod at the end of the clinker row. i had also attached the desired result. because in excel the formula are implemented at the cell level so the Quarter calculation should not impact the below rows. I have to implement some other formula for other rows which are different for other each row. 

Please let me know if you have any questions.

Best Regards,

Kaustubh

[atcodedog05]

Hi @Kaustubh17 

You can apply formulas to specific rows separately and later union it later.

That can Row-1 can follow different calculation and Row-2 to end can follow different formula.

Happy to help : )

Cheers and have a nice day!

[Kaustubh17]

Hi @atcodedog05  if the result is transpose then how we can do that. I had attached the Screenshot of the result. but Q1, Q2, Q3 and Q4 repeat the same calculated value  for clinker Prod. Its making quite tough to replicate the Excel formulas on the Alteryx. Is there any way how to deal with this kind of situation where each excel cell is having formula and i have to replicate on the Alteryx. to deal with such situation what is the best approach if any suggestion. Please advice.

Best Regards,

Kaustubh

[atcodedog05]

Does the month columns keep changing or is it static?

[Kaustubh17]

@atcodedog05 its changing right now is 25 later that will be 26 and so on that's why i transpose the data, so that in future the column will not increase only the rows will increase.

[Raj]

@Kaustubh17 
find the worflow attached
mark done if solved.