We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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