How can I perform the sum function in columns and rows of Excel in Alteryx?
I am glad this was posted separately! Sums by rows = Formula, Sums by column = Summarize
But if you want further help, you'll need to provide more information
Thanks for your prompt reply. I combine 2 very big Excel files 11M and 15M and show you part of the files below.
The original combined file is 29M with 1411128 row. The file contains information about non performing loan (NPL). I want to add up from Right_2004_01_01_00_00_00 to Right_2022_11_01_00_00_00 to calculate the total repayment of each account ID. In addition, I want to answer the following 3 questions. Would you please tell me a quick way to do it? Thank.
Transpose and Crosstab will be your fastest way for dynamic aggregation - I think you may need to go through some of the interactive lessons and the learning path to learn Alteryx as it seems like this is a new tool to you!
The other questions are beyond the scope of typical community questions since they require industry expertise, so hopefully someone can help
I also guess Transpose and Crosstab can work for it. However, I think there may have other quicker ways to do it, as it is just a simple function in Excel. Thanks for your advices.
You can use the same SUM function in Alteryx in a Formula tool, but just like Excel it won't be dynamic when new columns come in to sum - Transpose and Crosstab would be your best option for dynamic aggregation.
If you don't want dynamic processes, then use a SUM if you are summing a row, or a Summarize if you are summing a column
