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

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

 

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

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

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 

Meoth
8 - Asteroid

This logic worked well. Thanks much Roland. 

Labels
Top Solution Authors