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
@Kaustubh17 can you provide the expected output?
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.