Hi Community
I am working with a super large data set (this is some sample data) where I have the spend per employee, per month over a period of time (12 months).
| Employee | Feb | Mar | Apr | May | Jun | Jul | Aug | Grand Total |
| Jane Smith | | $ 385.00 | -$ 180.02 | $ 27.09 | | | | $ 232.07 |
| Bob Apple | 439.84 | $ 2,856.06 | $ 174.99 | $ 14.99 | | | | $ 3,485.88 |
| Betty Davis | 11280.84 | $ 15,134.90 | $ 15,407.19 | $ 5,547.34 | | $ 10,040.90 | | $ 57,411.17 |
| Elton John | | $ 586.50 | $ 24.20 | | $ 2,674.56 | | | $ 3,285.26 |
| Dylan Bobby | | | $ 719.87 | | $ 4,267.34 | $ 6,802.04 | | $ 11,789.25 |
| Francis Smith | | | | $ 134.30 | $ 1,320.09 | $ 1,717.75 | | $ 3,172.14 |
I want to run a script in Alteryx which basically says 'find the highest monthly spend over the 12 month period for this employee' and repeat that for every singe employee in the dataset.
This was accomplished fairly simply in Excel with the following formula (=MAX(C5:I5)) which gave me a table like this:
| Name | Max Spend/Month |
| Jane Smith | $ 385.00 |
| Bob Apple | $ 2,856.06 |
| Betty Davis | $ 15,407.19 |
| Elton John | $ 2,674.56 |
| Dylan Bobby | $ 6,802.04 |
| Francis Smith | $ 1,717.75 |
that I could then perform further analysis on.
I have been trawling through old community posts and have seen variations of the cross tab, summarise and formula tools offered as suggestions but unfortunately I just cannot get them to work in this instance.
Help appreciated! 🙂
