12345
2020006
3122.57
12345
2020006
1649.25
12345
2020005
195
12345
2020004
2808.75
12345
2020003
1113.75
12345
2020002
9208.5
12345
2020001
9227.25
12345
2019012
15242.22
0
12345
2019012
5472
12345
2019011
13790.25
12345
2019010
6142.5
12345
2019009
3263.75
12345
2019008
8068
12345
2019007
13229.5
12345
2019006
14420.75
12345
2019005
11515
12345
2019004
7541.25
12345
2019003
1396.75
12345
2019002
4403.5
12345
2019001
3793.75
12345
2018012
2023.5
Simple
IsNotNull
Adjustment
True
fixed
2021-05-04 16:55:02
0
2021-05-04 16:55:02
2021-05-04 16:55:02
Isolate Adjustment Rows
!IsNull([Adjustment])
Allow
Append Everything
Append Everything
[Adj_Period] >= [Period]
Custom
Filter out future periods
[Adj_Period] >= [Period]
Calculate Total Sales
Calculate Total Sales
RecordID
1
Int32
6
0
Join Back Together
Join Back Together
Value Calculations
Percent of Total = [Sales] / [Total Sales]
Adj Sales = [Adjustment] * [Percent o...
Warn
Transpose Data
Transpose Data
Create Label Names
Cross tab data
Cross tab data
Ignore
All
ByName
Union with Adjustment Rows
Union with Adjustment Rows
Reorder Columns
Reorder Columns
ID - Ascending
Period - Descending
Adjustment - Descending
C:\Users\PA152096\AppData\Local\Temp\Engine_46660_6ed427165a7d4193a5aa0f0bc9f43bd4_\Engine_14544_56eb3b117b3e40d09fdeca7e6e3b7ee7_.yxdb
Single
Profile
Horizontal
Aggregate Adjustments