Hello @Edu_XGomes,
I think your company will in time come to appreciate the efficiency gains that Alteryx has to offer. Could you please clarify your question? Is the spreadsheet you attached the way your source data looks or does it start out more granular?
I don't know how helpful this would be but below I kind of think through your problem from the perspective of trying to identify the tool to use to accomplish a specific task...
| If you want to... | Then you should try... |
| Perform a function/calculation/formula involving multiple columns on each row | the Formula tool. The formula tool can redefine existing columns or create new ones based on almost whatever kind of calculation you want. For example, you can use the Formula tool to create the "amount people * factor to multiply" column in this problem. |
| Calculate a metric or summary statistic on a column of data | the Summarize tool. This tool has a lot of options to get various metrics on a column of data. For example, to get the Standard Deviation of cells A4:A8 in your spreadsheet, you would first filter your data to exclude the last row (i.e. row 9) and then use the Numeric --> Standard Deviation option in the Summarize tool. |
| Perform a SUM like in Excel | Sum option of Summarize tool |
With a combination of Formula and Summarize tools you can calculate your weighted average ticket cost as well.
