Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Combine or Add together Current month totals

SashaAmerican
7 - Meteor

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 

4 REPLIES 4
SashaAmerican
7 - Meteor

any starting points ?

SashaAmerican
7 - Meteor

this is where i am at so far

CoG
14 - Magnetar

Have you tried using the Summarize Tool to compute the sum after Union?

SashaAmerican
7 - Meteor

trying that tool 

Labels
Top Solution Authors