In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Calculate value of a row based on condition in another column

tsong57
5 - Atom

Hello,

 

I am looking for a way to automatically calculate the highlighted numbers in the example dataset below. The WTD for a particular year is equal to the number in the same Value column when WTD Condition is "x". The MTD for a particular year is the sum of number in Value when MTD Condition is "x". Is there a way to calculate this using the multi-row field tool? Thank you in advance!

 

YearWeekValueWTD ConditionMTD Condition
2023week 174 x
2023week 292xx
2023week 399  
2023week 450  
2023WTD92  
2023MTD166  
2024week 16 x
2024week 229xx
2024week 385  
2024week 449  
2024WTD29  
2024MTD35  
2025week 180 x
2025week 287xx
2025week 35  
2025week 427  
2025WTD87  
2025MTD167  
2 REPLIES 2
aatalai
14 - Magnetar

@tsong57 try this workflow attached.

 

Let me know how you get on

Qiu
21 - Polaris
21 - Polaris

@tsong57 
Maybe we can try a bit more dynamic way as below.

I alway like the tool "Transpose" and "Cross Tab", which are powerful for multi-column data processing.

0424-tsong57.png

Labels
Top Solution Authors