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

Question

Hi team,

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

Apr-24May-24Jun-24Jul-24Aug-24Sep-24Q1-24Q2-24Q3-24total CategoryUnit322567345897765345   Category1          ARs2344555462336778=Cat2A*Cat3A  BRs456123456789345234=Cat2B*Cat3B  CRs5766567787878445347   DRs12567890234567   ERs122333232434543456   TotalRs         Category2Kwh2344555462336778   AKwh456123456789345234   BKwh5766567787878445347   CKwh12567890234567   DRs122333232434543456   ERs         Category 3          ARs2344555462336778   B%456123456789345234   CRs5766567787878445347   D%12567890234567   ERs122333232434543456

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

apathetichell · Answer

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.

binu_acs · Answer

@Kaustubh17 can you provide the expected output?