Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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

Sum different rows (Multi-Row Formula)

gee158
5 - Atom
‎11-15-2018 03:07 PM

Hello!

 

I just started working and experimenting with Alteryx, and I'm having a little trouble while trying to use the multi-row formula to sum different rows. In the attached .xlsx file you can see the columns and rows I am working with, and the expected results.   

 

I hope someone can help me out, thank you very much! 

Preview file
13 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
kat
12 - Quasar
‎11-15-2018 03:22 PM

Hi @gee158

 

Welcome to Alteryx!

 

Here's the formula which should help you get it right

multirow.PNG

 

Cheers

Kat

multirow.yxmd
Reply
gee158
5 - Atom
‎12-03-2018 03:36 PM

Thank you Kat!

 

This worked perfectly!

Reply
0 Likes
register for inspire
designer new user guide
Labels
Top Solution Authors
View All