Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

SUMIFS

Meoth
8 - Asteroid
‎04-14-2020 10:16 PM

Can anyone please help me implementing below attached Data Set in Alteryx? 

 

Please consider "Data" tab to be build in Alteryx.

Preview file
55 KB
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula
‎04-14-2020 11:38 PM

Hi @Meoth ,

 

I think, using a Filter tool to remove rows without entry in Adjustment and a Summarize tool to sum the amounts by criteria in columns A, B and D does the job. I've attached a sample workflow. Let me know if it works for you.

 

Best,

 

Roland 

SumIfs.yxmd
Reply
0 Likes
Meoth
8 - Asteroid
‎04-15-2020 01:36 AM

This logic worked well. Thanks much Roland. 

Reply
0 Likes
Labels