Alteryx Designer Desktop Discussions

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

Month Wise YTD

PhaniManepalli
5 - Atom

Dear All, 

 

i have this specific view I am trying on a data sets as follows to achieve the YTD column from the below  please could any one suggest a workaround

 

Month   Name  MTD   YTD

Jan'19   ABC    1         3

Feb'19   ABC    1         2

Mar'19   ABC    1         1

 

i have 3 rows for a person in different months of a year; I am looking for a YTD count 

in decreasing order . any ideas?

 

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @PhaniManepalli ,

 

Attached is an example showing how to get that done

fmvizcaino_0-1578970065848.png

 

 

Let me know if that works for you.

Best,

Fernando Vizcaino

PhaniManepalli
5 - Atom

Thank you Very much 

Labels