Greetings, my fellow Alteryx warriors there are 4 attachments that have formulas to combine the totals of the month of July 2024 from 3 different spreadsheets "Awards redemption by Month Enhance with Miles", "Awards redemption rundown by month usage", ETV Report July"
In the attached file, “07.2024 Award Ticket ATL and Breakage”, column JT, rows 173-184, and rows 230-241, we are pulling in the July 2024 data from 3 different reports. I’ve attached the 3 different reports we are linking into the file.
MY Question can i get assistance on how to use the formula tool to total all 3 data points from the spreadsheets to automatically for July i also added the Alteryx workflow to the question
any starting points ?
Have you tried using the Summarize Tool to compute the sum after Union?
trying that tool