Product A
502
991
352
723
884
641
653
857
715
683
900
150
Product B
345
613
933
194
676
366
870
430
670
507
234
716
Product C
929
393
207
855
607
702
562
677
963
164
286
655
Sample Data
Sample Data
Warn
Transpose grouping by product
Transpose
Create a Date_String field by appending the current year and first day of the month
Date_String = [Name] + "-01-" +
//If the current month is January (1)
IF DateT...
Date_String
English
MMM-dd-yyyy
Date
Convert the Date_String to a date field
Convert Date_String From:
Custom
[Date] = ToDate(DateTimeAdd(DateTimeFirstOfMonth(), -1, "months"))
Custom
Filter to the current month (current month -1)
[Date] = ToDate(DateTimeAdd(DateTimeFirstOfMonth(), -1, "months"))
[Date] <= ToDate(DateTimeAdd(DateTimeFirstOfMonth(), -1, "months"))
Custom
Filter to all preceding months
[Date] <= ToDate(DateTimeAdd(DateTimeFirstOfMonth(), -1, "months"))
Summarize by product
Summarize by product
Error
Join all results by product
Join all results by product
Product - Ascending
C:\ProgramData\Alteryx\Engine\Engine_20172_692ee25dc7e27a439bc33d5e2749f84d_\Engine_20172_61203aa0ad1a11488543cb8f15c1b5e2~.yxdb
Single
Profile
Horizontal
YTD_v2