How to do row and cell level formula same as excel, but i have to do it in Alterxy

[Kaustubh17]

Hi team,

I have the below kind of data in the excel this is a dummy data.

		Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Q1-24	Q2-24	Q3-24
total Category	Unit	322	567	345	897	765	345
Category1
A	Rs	234	455	546	233	67	78	=Cat2A*Cat3A
B	Rs	456	123	456	789	345	234	=Cat2B*Cat3B
C	Rs	576	6567	78	7878	445	347
D	Rs	12	56	78	90	234	567
E	Rs	122	333	232	434	543	456
Total	Rs
Category2	Kwh	234	455	546	233	67	78
A	Kwh	456	123	456	789	345	234
B	Kwh	576	6567	78	7878	445	347
C	Kwh	12	56	78	90	234	567
D	Rs	122	333	232	434	543	456
E	Rs
Category 3
A	Rs	234	455	546	233	67	78
B	%	456	123	456	789	345	234
C	Rs	576	6567	78	7878	445	347
D	%	12	56	78	90	234	567
E	Rs	122	333	232	434	543	456

I am able get the desired format in the Alteryx but the main challenge is for the Quarter values each cell have formula implemented into it but not sure how i can implement the formula at cell level. I need to understand how I can calculate the Quarter values base on categories at cell level. because it very complicated to get the formula for cell level. Some are direct sum values but some formula are the combination of multiple Categories values. 

Please need the solution.

Thanks,

Kaustubh

[binuacs]

@Kaustubh17 can you provide the expected output?

[apathetichell]

This is not how you would do things in Alteryx because Alteryx is not a spredsheet. You would create a wider data structure so that if CatA row 1 is going to be multiplied by CatB row 1 and/or CatCRow1 - Row 1 includes the CatA/CatB/CatC columns - then you multiply out in formula tool as needed.